Hello

I have created a find duplicates query that returns a list of items and the numbers of dupes for that item. How can I get the query to show me all the dupes it finds so that I can delete the one I don't want?

Your help is greatly appreciated!

The find duplicates wizard produces a query that shows you all duplicates, not just a count. You can use this query to delete records provided the table has a unique identifier. If you find yourself unable to delete the dupes, you'll need to add an autonumber field to the table and make it the primary key. Access will then allow you to delete the "logical" duplicates. Once the "logical" dupes are deleted, you can delete the autonumber column and change the primary key to what ever columns are necessary to prevent future "logical" dupes.