Delete duplicates within one table

[zbreima]

I have on table and I would like to delete duplicates of a single column regardless of other columns. The situation is that I have alot of Location information with addresses and phone numbers and I would like to weed out the duplicates by the phone number of the location. So essentially I have ALOT of records in and want to only show records with distinct phone numbers. Please help

[llkhoutx]

I would use DAO or ADO code to cycle through a dynaset of the duplicates, deleting those dynaset records not to be kept. However, which is kept.

I don't think that you thought through the data issue.