DELETE DUPLICATES but only Leave 1 Record (ACCESS 2010)

[taimysho0]

hello, i dont see a delete duplicates wizard in 2010 access. how do i delete all rows of duplicate records, but only leave one row of that record? so any other row that is a duplicate, delete them? thanks

[taimysho0]

be something like if the count of each value in each column is > 1, then delete?

[orange]

Do you have a primary key on your table?
What makes a record a duplicate?

http://support.microsoft.com/kb/209183