I have a access database containing a table called Contact, the table contains these fields Name,Address,Phone. I need to find the duplicate phone #'s and remove all but 1 of them from the database. I do not have a primary key and I cannot add one. (if I add it I have to do it programatically) Any Idea how to do this without looping thru the database (some of these databases contain over 10,000 rows ) ????

Jean-Guy