Microsoft Office Tutorials and References
In Depth Information
Finding Unmatched Records with a Wizard
4. Select the table (or query) that should contain the matching records
for the data in the table you selected in Step 3 and then click Next.
If you’re looking for customers with no orders, select the table that
holds the order information. If you’re looking for orders that don’t have
the customer address, select the table that holds customer addresses
when you do this step.
5. Check to make sure that Access correctly guessed the related fields in
the two tables you selected in the third window of the wizard (shown
in Figure 3-10); if it did, click Next.
fields to find
The window shows field names in the two tables you selected. The
names of the related fields probably are highlighted. Click the related
field in each table if Access hasn’t selected the correct related fields.
The two fields that you select should contain the same information and
be of the same data type.
6. Select the fields you want to see in the query results in the next
window of the wizard and then click Next.
To select all fields, click the double arrow pointing to the right.
7. Accept the name that Access gives the query, or name the query
yourself in the final window of the Find Unmatched Query Wizard.
Access is good at naming the results of this query descriptively. Notice
whether the name reflects the query you thought you were creating. If
not, click the Back button to redefine the query.
8. Choose whether you want to view the results or modify the design and
then click Finish.
Access displays the query in Design or Datasheet view, as you