How to Use the Wizard to Create a "Find Unmatched" Query in Microsoft Access

A Find Unmatched query will locate records in one table that do not have related records in another table. For example, you could find customers that do not have orders pending. These instructions apply to Access 97.

Things You'll Need

• Microsoft Access

Instructions

1. Open the Database window.

2. Click the Queries tab.

3. Click New. The New Query dialog box appears. Click Find Unmatched Query Wizard. Click OK.

4. Follow the wizard's instructions to select the tables you want to compare. Click Finish when all the information is entered.

5. Run the query or see the query's structure in Design view.

Tips & Warnings

• You can make changes to your query in Design view.

• Related records occur in tables that are joined by a relationship; the related records have the same primary key. For more on relationships, see Related eHows.