Finding values that are duplicated so I can Create an NO DUPLICATES index

[HDobler]

I am using Access 2010 32-bit on a Windows 7 64-bit platform.

I have a database that I have imported existing data into. For the most part, I have eliminated duplicate entries in my Item Number field.

Obviously I have missed at least one (or possibly more) duplicates. When I try to create a NO DUPLICATES index, I am informed that there are duplicate entries.



I am looking for a quick way to generate a list of values that are duplicated so I can address those and correct them.

Item number field is a number field of type DOUBLE with 2 decimal places.

Thank you in advance for suggestions.

HDobler

[JoeM]

This is really easy to do with an Aggregate Query. Here is how:

1. Create a new query.
2. Add the field you want to check for duplicates to the query TWICE
3. Click on the Totals icon (looks like a Sigma)
4. This will add a Totals Row under each field in Query Builder with the words "Group By" under each field. Under your second field, change "Group By" to "Count"
5. On the Criteria row under that second field you just changed, enter the criteria: > 1

Now view your query. It will show you all entries that have more than one listing.

[HDobler]

Thank you Joe.

That work great and is very easy.