G
Gwen
I have two tables that contain one field that I want to
compare on. I need to compare one field (Address) between
the two tables and have it create a new table that
contains all records except for the duplicate records
found in the compared field and another table that has the
duplicate records. The structure for the two tables (field
names at least) are exactly the same. I did an unmatched
query but am suspicous of the results and since I couldn't
view the suspected duplicate records, I can't verify if
this worked correctly.
compare on. I need to compare one field (Address) between
the two tables and have it create a new table that
contains all records except for the duplicate records
found in the compared field and another table that has the
duplicate records. The structure for the two tables (field
names at least) are exactly the same. I did an unmatched
query but am suspicous of the results and since I couldn't
view the suspected duplicate records, I can't verify if
this worked correctly.