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:

Asked by vpxoxo
(121 rep)
Jan 26, 2016, 07:05 PM
Last activity: Jan 27, 2016, 05:26 PM
Last activity: Jan 27, 2016, 05:26 PM