Remove duplicate records in table

[l2fsh]

I have a table with a field called "part number"

There are many redundant records and I want to eliminate the duplicates. Any ideas would help.

Thank you

 

[traingamer]

You can use the find duplicates query wizard to run a query to find duplicates.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[BNPMike]

What I would do is add a new field DeleteFlag (type Yes/No) and then write a query that selects all records where there are duplicates - use a subquery to do this. You can then visually inspect the duplicates and set the delete flag for the ones you want to go.