Comparing Data in 2 Tables

S

Scott

I need to create a query that compares data in 2 tables. If the data exists
in one table but not in the other, the query should take those exceptions and
put them in a new table. Any ideas how this should look?
 
O

Ofer Cohen

Start with creating an unmatch record query, using the query wizard, that
will return the record that exist in one table but not in the other.

After you achieve that, change the query from select query to append query
to append the record to the third table.

But remember that to display the extra records yo can use the above select
query, you don't have to append the records to a new table
 
G

George Nicholson

Start with creating an unmatch record query, using the query wizard, that
will return the record that exist in one table but not in the other.
Click to expand...

....And then repeat the steps, reversing the comparison.

Identifying records in TableA that aren't in tableB is one "Unmatched"
query.
Identifying records in TableB that aren't in TableA is a second.

HTH,
 
Top