how to find all duplicate rows in access 2007 ?

Question

hi

need help with query that find all duplicate rows in access 2007

i have ID (text - not unique) and Name (text)

i need to find all the rows that ID is duplicate

thank's in advance

Answer 1

You can use the COUNT function

SELECT Table.ID
FROM [Table]
GROUP BY Table.ID
HAVING (((Count(Table.ID))>1));