J
John
I have two tables that were originaly Excel tables and imported them into
Access. Import went well. Both tables consist of columns named - Name,
Department Number, Department Name, and Employee ID. I need to compare the
two tables and have Access give me the NON duplicates.
I ran a Find Unmatched Query using name in both tables. The results showed
almost as many records as are in the original two tables. What I noticed it
found in one table Smith, John and Smith,John. These are the same people but
one person typed the name with the last name and comma space while the other
person who typed the other table omitted the space. Therefore I think the
query is seeing this as two seperate people because they do not match
exactly? Unfortunatly they left the name coulmn with the last ane and first
name not seperated into two separate fields.
Any help would be appreciated.
Access. Import went well. Both tables consist of columns named - Name,
Department Number, Department Name, and Employee ID. I need to compare the
two tables and have Access give me the NON duplicates.
I ran a Find Unmatched Query using name in both tables. The results showed
almost as many records as are in the original two tables. What I noticed it
found in one table Smith, John and Smith,John. These are the same people but
one person typed the name with the last name and comma space while the other
person who typed the other table omitted the space. Therefore I think the
query is seeing this as two seperate people because they do not match
exactly? Unfortunatly they left the name coulmn with the last ane and first
name not seperated into two separate fields.
Any help would be appreciated.