change Find Duplicates To Delete Duplicates ?

[p27br]

hi,

generally speaking, I'd like to be able to transform a Find Duplicate query into a Delete Duplicates query.
How would I have to proceed ?

thanks

 

[danvlas]

First you need to identify which duplicates to delete (you need a key element to display in the Find Duplicates query)
Use the Find Duplicates query as source for an 'In (Select...) statement. The In(Select...) should contain a Where clause to return ALL keys BUT the one that must remain in place.

But I think it's easier in code, using a recordset based on the Find Duplicates query.

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[p27br]

danvlas

thanks for answering.
I doesn't really make things clearer but I'll try out the code idea.