Two Tables

  • Thread starter Thread starter Galsaba
  • Start date Start date
G

Galsaba

How can I make a query that find all items that appears in one table, but not
in the other.

Let's say that I have a list of customers 2002, contains cusomers name,
address, etc. Then I have another list of customers, costomers 2003. I want to
see only those cusotmers which are in 2003, and not in 2002.

Thanks,
Aaron
 
Hi

under the NEW icon (button) in the query section you will find the unmatched
query wizard which should give you what you're after.

Cheers
JulieD
 
Back
Top