how do I combine 2 tables into 1 table without losing data from e.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The 2 tables have similar data - the key field for both tables is the serial
number. I need to condense the records in both databases to one database -
but I need to see what records don't match up exactly. I seem to recall a
"match" query I used years ago - but I cannot locate any help on it now.
 
Joyce

Are both tables "linked to" or physically included in the same .mdb file?
That's a starting point.

The query wizard offers an "unmatched" query wizard that helps you select on
which fields you wish to check for (un-)match.
 
Back
Top