Hi. I have an ms/access database that has a table from which I need to delete records according to specific criteria.
This is [myTable] with a key, [myTableKey]
I have a set of analysis, running from other tables that yield keys [myTest1Key], [myTest2Key], ... [myTestNKey]. I need to delete the records from myTable where [myTableKey matches the [myTestiKey], so the [myTable] is totally cleaned out.
How do I do it?