troubleshooting Question
ms/access deleting records based on a query
asked on
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?
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?
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.