Two Tables

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
 
J

JulieD

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
 
Top