[ Team LiB ] Previous Section Next Section

Finding Unmatched Records

graphics/microsoft149_1.gif

When you have related tables, you might want to find which records in one table have no match in the other table. For example, if you have a table of products and a table of customer orders, you might need to know whether there are products that have no match in the Orders table. In other words, are there some products that no customer has yet purchased? Access provides a query wizard to help you answer questions of this type.

Find Unmatched Records

graphics/1_icon.jpg

In the Database window, click Queries on the Objects bar, click New, and then double-click Find Unmatched Query Wizard.

graphics/2_icon.jpg

Choose the table or query whose values you want displayed in the query. Click Next to continue.

graphics/3_icon.jpg

Choose the related table or query. Click Next to continue.

graphics/4_icon.jpg

Specify the field that matches records in the first table to records in the second. Click Next to continue.

graphics/5_icon.jpg

Choose which fields from the first table to display in the query results. Click Next to continue.

graphics/6_icon.jpg

Enter a name for the new query.

graphics/7_icon.jpg

Specify whether you want to view the query results or further modify the query design.

graphics/8_icon.jpg

Click Finish.

graphics/06inf17.jpg

    [ Team LiB ] Previous Section Next Section