Query: Qry Find Dulicate People for Merge

Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: Yes

Tables Referenced

• People

Columns Selected

• People.[First Name]
• People.[Last Name]
• People.[ID Number]
• People.[People ID]
• People.[Import ID]

Where Clause

(((People.[First Name]) In (SELECT [First Name] FROM [People] As Tmp GROUP BY [F

Order By

People.[First Name], People.[Last Name], People.[ID Number]

SQL

SELECT People.[First Name], People.[Last Name], People.[ID Number], People.[People ID], People.[Import ID] FROM [People] WHERE (((People.[First Name]) In (SELECT [First Name] FROM [People] As Tmp GROUP BY [F