find and delete duplicate records

  • Thread starter Thread starter mcnewsxp
  • Start date Start date
M

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
 
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
 
Back
Top