Similar table record comparison

[Bernadette]

I have a table in my MS Access 2000 that I update monthly
from records imported from a different database. Before
updating the table, I archive a copy of it in the current
database.

After I've updated the table, how can I create a 'select
query' to compare the 2 tables to see which records were
edited?

Thanks in advance...

 

[chas]

Hi Bernadette,

try using the 'Find Unmatched query wizard'.

hth

chas