Duplicate Query

[whitestone]

I have some bio-geographical data held in a table (names and addresses) which has a series of duplicate rows.
I have run a find duplicate query to pick out all the dupes. I now want to delete the duplicates However, the query picks out all of the rows when they occurr more than once. For example, if there are two rows for a Mr Smith at 1 Sample Street in the table both will be picked up in the query. Therefore I can't just change the query into a Delete query because I want to keep one record for (in this case) Mr Smith.
Is there any way of automatically deleting the duplicates but leaving one record for each person?

Cheers
Ben

 

[AncientOne]

First, create a select query and stipulate unique values in the Query Properties. Make sure that this returns the required records. Then convert to a make-table query and run it. This gives you a new table of unique records. Now delete or rename the original table and rename your new table with the old table's name.