Use the Find Unmatched Query Wizard to create a query that shows records from one table that have no corresponding records in another table. This type of query is useful for finding employees who have no sales records or vendors who have no purchase orders.
To run the Find Unmatched Query Wizard:
When selecting the field(s) to search for unmatched values, remember that the fields might be named differently in the two tables. For example, the Product field in the Order table might contain the same values as the ProductOrdered field in the Inventory table. |
|
To start the Find Unmatched Query Wizard:
|