[AccessD] Eliminating duplicate rows

Bruce Bruen bbruen at bigpond.com
Thu Jun 12 20:40:46 CDT 2003


Dear List,

Due to a (ahem) programming feature, I now have a table with several
thousand rows of which hundreds are redundant.  I am loking for a way to
delete the redundant rows.

I have used the previously discussed method of using a max (recID)
subquery in a delete query before, but it will only eliminate one of the
duplicates at a time.

Short of running the delete query over and over until they are removed,
is there a way to get rid of all but one of the duplicates?

tia
Bruce



More information about the AccessD mailing list