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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to combine two tables into one table 2
Counting multiple memberships 1
loop thru records to create a union query 1
combine tables 1
embeded forms 6
Linking tables/relationship 2
updating a table from a form 1
Two tables 1

Back
Top