Sample Header Ad - 728x90

How to compare two tables that have no primary key?

2 votes
1 answer
5304 views
So I got two sets of tables at work that I have to compare the data. The fields are identical, but there is no column that has unique entries. (Employee ID, Assignment ID, Employee's last name, Employee's First Name, Dependent Last name, Dependent First name, Dependent Date of Birth) An employee can have multiple assignments, and each employee can have multiple dependents. The data of the two tables were entered by different people and so they are messy.. and I was asked to do some data cleanup. Some of the dependents can be missing for an employee, or the dependent's name is spelled wrong /blanks etc... Is there a way to compare the two tables for unmatched records, so that I can create a table for all data? I tried to use Find Unmatched Fields query in Access but it can only compare one field? Thanks in advance!:) ==edit== I'm adding some sample data here: enter image description here
Asked by vpxoxo (121 rep)
Jan 26, 2016, 07:05 PM
Last activity: Jan 27, 2016, 05:26 PM