2 Tables to merge

[simon4amiee]

I have 2 tables of data from different sources,

Table 1 - Surname,Forname,JobTitle - (ManuallyEnteredontoDB)

Table 2 - FirstName,Middlename,Surname,JobTitle - (StaffList)

My objectives are:

Merge to 2 tables
Find any duplications

 

[DrSnuggles]

If it's duplications you are concerned with I would:

1. Insert the data from both tables in a new table. (Use fields from Table 2 to create the new table first).
2. Then create a SELECT Query on the new table, using a 'Group by' on the three similar fields. Add one of the similar fields again, select 'Count' instead of 'Group by' and in the Criteria put: >1.
This will list all the duplicates.