delete duplicates from query

[Guest]

I have not gotten anywhere i have asked 4 times for someone to help me to no
avail

can someone email me at (e-mail address removed) and please help me

I have a database with 30,000 duplicate phone numbers, i want to delete all
the duplicates and leave just one, for exampl if i have 8 same numbers I want
to delete all but 1,

i know how to do it manually but that would take forever, please someone
help me i am not very bright and dont know much abotu access, so pleas
eexplain step by step i would appreciate it very much

benjamin fraga

 

[John Spencer]

What other fields do you have in the table?
If you have 8 records with the same number, which one of the eight do you want
to keep? Or does it matter at all.
Is this a one time process? If so, it can be done manually.

Can you post the SQL statement of the query that gives you all the duplicates?

Open the query in design mode
Select SQL from the view menu
Copy and paste the code.