DELETE duplicated Records

[Guest]

Hello I have TABLE named:IDVolatilDBID_lbl
and I have a column named: WO ID
and in a FORM I have a button named Delete_DR

I want to delete all duplicated records using as reference WO ID
I need to put the DoCmd.RunSQ on the button Delete_DR but I have tried many
times and it does not work

could you help please?

 

[Guest]

Hi Lorenzo,

I have to start by asking, why do you get to a point that you have
duplicates if you want to delete them later on?
Why not avoid duplicates when data is enterd?

Also, when you want to remove duplicates are all the records identical, or
there is a rull to which record to delete (date last insert , counter)?