How To Delete Duplicate Values in a Table

[shadows]

Good morning all!
I have a problem, I have a contact list table in my database such as name, addr, company, street, country etc. The problem is that I have multiple duplicates of the same data.
How do i delete the duplicates? Is there an SQL query that I can run to delete? How do I do it. Please help. Thanks a bunch!

 

[DOLL]

Helo senor. You can also use filter in that table. It cuts down unnecessary records that has been duplicated.

 

[neileg]

There is a duplicate record query wizard in Access. Use this to build a query that finds the dulicates, then alter it to a delete query.

Once you have cleansed your data, consider applying a multi field index set to No Duplicates to prevent future problems.