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