I am using Access 2010. I have 2 tables with the same field names where one of the field names is email address.
What I need to do is compare the 2 tables and show instances where the same field for the same email address are different. It would be ideal if it showed me a side-by-side view showing what the value is in the first table and what the different value is in the other table, and showed multiple differences for the same email address on the same row.
I tried following the tutorial found at the link below, but it didn't seem to do what I wanted it to do. Anyone have any other tutorials for this?
https://support.office.com/en-ca/art...f10a5d1cb4#bm2
Bookmarks