How to find the differences between 2 Access tables???

[John Davis]

Given 2 Access Tables with identical fields, how can we find out the
differences between the records??

For example, in table1,
ID Name Amount
1001 N1 A1
1002 N2 A2
1003 N3 A3

in table2,
ID Name Amount
1001 N1 A1
1002 N2 A2
1004 N4 A4

i.e. Table1 - Table2 will yield record with ID 1004, and Table2 - Table1
will yield record with ID 1003?? any operations in Access can do that??


Please advice. Thanks!!!

 

[chas]

Hi John,

you could try the 'Find Unmatched Query Wizard' to see if
it gives what you need.

Under Queries, choose New and then 'Find Unmatched Query
Wizard' and follow the steps in the wizard.

hth

chas