• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Locating Specific Information... > Finding Unmatched Records

Finding Unmatched Records

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint