How do I compare 2 tables?

  • Thread starter Thread starter messenger69
  • Start date Start date
M

messenger69

I know this may sound simple to some people, but I
stumped.

I have 2 tables. 1 with old info and the 2nd with new
info. I need 3 results:

1. I need to know what overlaps in the new database and
the old database.
2. I need to know what never made it into the new
database.
3. I need to know what is in the new database that isnt
in the old one.

(e-mail address removed)
 
Hi

in the query section click on the NEW button (not any other method of
creating new queries) you should see two options there which should help -
the unmatched query wizard for Q2 & 3 and the duplicates query wizard for Q1

Let us know how you go.

Cheers
JulieD
 
Back
Top