Delete query......

[Paul]

How to create a Delete query to delete all the duplicate data from a table?
The table consists of 1PK and 5 other fields. I like to use all the fields
except the PK field to evaluate if a record is duplicated and delete the
dupplicate record(s) from the table. Thanks.

 

[Eric Cárdenas [MSFT]]

How to create a Delete query to delete all the duplicate data from a
table?

The table consists of 1PK and 5 other fields. I like to use all the fields
except the PK field to evaluate if a record is duplicated and delete the
dupplicate record(s) from the table. Thanks.

--------------------
You can't do it with a delete query. You need to write some VBA code to
step through all the rows and delete the duplicates. You also need to
decide whether you wish to delete the first duplicate or the second
duplicate.

Hope this helps,