How to find duplicate records in a table?

[Gkirkup]

I have a table on which I cannot set a primary key because there are duplicate records in the table. How can I use a query to show the records that are duplicated?

Robert

 

[John Big Booty]

You could use a Totals Query and Group By and also Count the field you are interested in. If the Count is greater than 1 you know you have duplicates.