Drew Wutka
DWUTKA at marlow.com
Thu Jun 12 21:14:35 CDT 2003
I believe you can use Distinct Row (Just look up Distinct in the help files). Drew -----Original Message----- From: Bruce Bruen [mailto:bbruen at bigpond.com] Sent: Thursday, June 12, 2003 8:41 PM To: accessd at databaseadvisors.com Subject: [AccessD] Eliminating duplicate rows 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