Query for finding master records NOT in another table

  • Thread starter Thread starter Ray Kanner
  • Start date Start date
R

Ray Kanner

I have two tables - one a master of accounts and the other
one of accounts that I need to invoice (the second table
may have multiple items for the same account, ie for each
item sold). I would like to create a query/list of the
master accounts that I am not currently invoicing. I must
be missing something, but there has to be a simple way of
doing that. Thanks in advance

Ray Kanner
 
Ray Kanner said:
I have two tables - one a master of accounts and the other
one of accounts that I need to invoice (the second table
may have multiple items for the same account, ie for each
item sold). I would like to create a query/list of the
master accounts that I am not currently invoicing. I must
be missing something, but there has to be a simple way of
doing that. Thanks in advance
Click to expand...

There is a "Find Unmatched Query Wizard" that will build this query for
you. If you click Insert -> Query, or click the "New" button on the
Queries tab in the database window, you'll be able to choose this
wizard.
 
Back
Top