Duplicate Query that deletes

[rgreene]

I have a table that has several records that are duplicates. Some are duplicated many times. I have a query that finds the duplicates but now I want it to delete all but 1. For instance if a record has been duplicated 4 times I want it to delete 3 records and leave 1.

 

[mark curtis]

take the data into Excel and delete the duplicates and then copy back into empty table or check out Pat's advice:

http://www.access-programmers.co.uk...hreadid=57641&highlight=delete+duplicate+rows