If Count of Row is > 1 Then Delete?? (Access 2010)

[taimysho0]

Hello, i have a lot of duplicate data. How do i write a query to delete the row if the row has a duplicate count of > 1??? Using access 2010. Than ks!

[taimysho0]

nevermind, solved. found the wizard to remove duplicates.

[Robeen]

Create -> Query Wizard -> Find Duplicates Query Wizard . . . complete the steps to finish creating and saving the query.
Then - if your query is showing you all your Duplicates ONLY - just teh way you expect - and if you want all your duplicates gone - you can convert the query to a Delete query and run that.
Hope that helps!