Query: Find duplicates for People ID Nymber

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

Tables Referenced

• People

Columns Selected

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

Where Clause

(((People.[ID Number]) In (SELECT [ID Number] FROM [People] As Tmp GROUP BY [ID 

Order By

People.[ID Number]

SQL

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