>In another thread, which almost exausted me, he told, that he doesn't have PK in his tables, since tables are produced from Excel. So, I'm thinking about
>delete from Original where recno() in (select RecNum from CopiedRecords). That's from the top of my head, I hadn't tried. Do you think, it would work? Otherwise he needs a loop, but I do not like this idea.
Methinks that as soon as the data is imported into whatever system he uses, he should add a primary key, to facilitate further manipulation.
IMNSHO, recno() is doubtful. A loop would be safer, but it might also be slower.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)