[AccessD] Eliminating duplicate rows

Susan Harkins harkins at iglou.com
Thu Jun 12 23:02:46 CDT 2003


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



More information about the AccessD mailing list