determining # of identifiers that have been removed, # newly created, when comparing two tables

[billyheanue]

Hi all big access n00b here.

I have two tables, table 1 and table 2, for sake of simplicity each one has two columns

Column A: autonumber
Column B: identifier (a unique ID i created for each record)

How can i tell the number of "identifiers" that existed on Table 1, that no longer exist on Table 2?
How can i tell the number of "identifiers" that did not exist on Table 1, that now exist on Table 2?


Big thanks!

 

[Joe4]

Access has a "Find Unmatched Query Wizard".
Use that to do what you want between the two tables (find the records in one that do not exist in the other).
It walks you right through the whole process.