[AccessD] Eliminating duplicate rows

Use the Duplicates Wizard to find the duplicates. Then, open the SQL window
and change the SELECT to DELETE...

make copies of your table and test it first -- just to be safe.

Susan H.

> 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
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>