find and delete duplicate records

[mcnewsxp]

what is the best way to find and delete duplicate records.
i know how to use the wizard to find.
how do i delete the dupes?

thanks,
mcnews

 

[Michel Walsh]

Hi,


Append the records in a table that does not allow duplicated values (
"n" records won't be append because of that, that is ok, that is what we
want),


or, make a query, inserting the keyword DISTINCT between SELECT and the
list of fields you select.



Hoping it may help,
Vanderghast, Access MVP