Find unmatched records between tables using a query wizard

Using the Find Unmatched Query Wizard, you can find records in one table that don't have related records in another table. For example, you can find customers who don't have orders.

1. In the Database window, click Queries under Objects, and then click New on the Database window toolbar.
   
   
2. In the New Query dialog box, click Find Unmatched Query Wizard.
   
   
3. Click OK.
   
   
4. Follow the directions in the wizard dialog boxes. In the last dialog box, you can choose to run the query or see the query's structure in Design view.

   If the resulting query isn't exactly what you want, you can rerun the wizard or change the query in Design view. For more information on changing a query in Design view, click .