[AccessD] Eliminating duplicate rows

Also ... if your data can fit this scenerio, try this:

Create a structure only copy of your table, go into design mode
and set an index on the data you do not want to be duplicated,
and set the duplicates allowed property to NO.

Copy all the data from your first table to your second table.
A database error will result telling you that the number of
duplicate records not allowed to be copies, however all of
the other records will be copied successfully.

Your second table is now your duplicate free table.

Michael R. Mattys
www.mattysconsulting.com

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