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?



--
Lorenzo DÃ*az
Cad Technician

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)?

--
Good Luck
BS"D


"ldiaz" wrote:

> 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?
>
>
>
> --
> Lorenzo DÃ*az
> Cad Technician