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