Delete Duplicate?

R

Racer57

When I use the query wizard to find duplicate records, is there an easy way
to delete all of the duplicate records in the query results?

Or if not using the wizard, what is the easisest way to delete duplicate
records?
 
J

Jeff L

Right click in the top window and select Properties. Change Unique
Values to Yes. Hope that helps!
 
J

John Spencer

Do you want to permanently delete all but one of each duplicate? If so,
here is an outline of ONE method to delete all but one of the duplicates.

ON A COPY of the database
-- Copy the table structure only (Copy and Paste)
-- Set an index (no duplicates) on the field that you used to determine
duplicates. If you used multiple fields you will need to set a multi-field
index
-- Create an append query that will append all the records from the original
into the copy. You will get an error saying xx records can't be appended
due to ... The query will append one of the duplicate records and drop the
others.
-- After the append runs, open up the new table and see if all the records
you want are there. If so, rename the original (just in case) and then name
the copy with the original name.
 
J

John Spencer

Must have missed your posting/request on that. Then again, I don't see
every posting. Don't have the time
 
Top