Hi there,
I would appreciate your advice on the right way to do this :
i have a recordset, of wich I would like to delete the records where the field horas and the field ano is repeated in one or more records
in this case i would like to delete the records with maqID 6 and 7
what is the best way to achieve this ? the recordset is based on a recordsetclone of my current subform
thanks for your help
I would appreciate your advice on the right way to do this :
i have a recordset, of wich I would like to delete the records where the field horas and the field ano is repeated in one or more records
maqID | ano | horas |
1 | 2002 | 6300 |
2 | 2003 | 6300 |
3 | 2002 | 6400 |
4 | 2015 | 2530 |
5 | 2014 | 8444 |
6 | 2009 | 1630 |
7 | 2003 | 8223 |
8 | 2009 | 1630 |
in this case i would like to delete the records with maqID 6 and 7
what is the best way to achieve this ? the recordset is based on a recordsetclone of my current subform
thanks for your help