Delete query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a delete query that deletes records from both tables in a
one-to-many join. Both tables have corresponding social security numbers,
but the deletion criteria is Termination Date Is Not Null with the
Termination Date field in the primary database only. This is probably easy
but I've tried a couple things that haven't worked. Can you help? TIA!
 
Thanks, looks like unique records did the trick! Also thanks for the quick
response.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Query: Could not delete from specified tables 0
Error in Delete Query 6
Have both records from two queries/tables under one Query without related fields. 0
Delete query with joined tables 0
Access 97 delet query problem 1
DELETE QRY issue 4
Delete query based on criteria in a linked table 5
Delete query using criteria from another query 1

Back
Top