Unmatched Query not working

[mkelly]

I have a a table that changes monthly, and each month I need to find the records from the old table that are not in the new table and visa versa. I made the entire row in the table the key.
and wrote two find unmatched queries.
However, the queries are not finding all the information that is no longer there or that has been added.
Can someone please take a look and see what I am doing wrong?
Any help appriciated!!
Thanks


the tables are imported from Excel

 

[Murli]

Hi,

The unmatched query you used on the field last name will not work as there are multiple rows with the same last name. Inorder to make the query run the entire record has to be compared between the two tables and not just the last name.

I have made the corrections in the attached file.

Murli

 

[mkelly]

Thanks for the insight and the help!