Dupes in a large table

[Crilen007]

I have a table i imported from an ODBC

There are a few dupes in the main ID column, however there are 15k entries, any easy way to pick these out?

Thank you

 

[GumbyD]

Create a grouping query and bring in the ID field twice. In the first column "GroupBy" the ID field, In the second Column "Count" the ID field. In the criteria under the Counted ID's put >1 that will show you all the ID that are in more than once.

GumbyD

 

[Crilen007]

Thank you lots =D