Deleting duolicates

[Jazztpt]

I have the data from a membership DB which has quiet a few duplicated Names and addresses (though they may have a 'type' field which is different)

I have identified these using the find duplicates wizard. Is it possible to use this query to delete the duplicated entries and leave one record. or is there another method.

Thanks
Jazztpt

 

[Jazztpt]

Of course the title of this thread should have said 'Deleting Duplicates'
Jazztpt

 

[Jazztpt]

Found the solution - need to copy the structure of the table and make the fields with duplicates in Primary Keys. You then create an append query from the table and append to the new table. The query will not duplicate values due to the primary key.
Jazztpt