Delete query......

  • Thread starter Thread starter Paul
  • Start date Start date
P

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.
 
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.
Click to expand...
--------------------
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,
 
Back
Top