Combo Find Duplicates and Delete query - TechRepublic
General discussion
September 26, 2000 at 03:10 AM
johnnyextreme

Combo Find Duplicates and Delete query

by johnnyextreme . Updated 25 years, 9 months ago

In Access 2000 I have a Customers table with a lot of duplicates. I know how to write a Find Duplicates query and how to write a Delete query. How can I write a query (or more than one query) that will find all the duplicates then delete all but the first instance of the customer record, leaving only unique records? A good answer to this would save me DAYS of work.

This discussion is locked

All Comments