Jump to content
jpkelly

DELETE query criteria question - MS Access 2010

Recommended Posts

Hello, New at this DELETE thing. I wish to write a DELETE query that will remove records from the 'REPAIRS" table. The conditions that must be met is that the "active" field = false in the "REPAIRS" table and that the "tradeID" field in the "REPAIRTRADE" table = cet. I'm confused about the statement needed and the syntax. Any help is truly appreciated.

Share this post


Link to post
Share on other sites

I don't see an active field in the repairs table, but from your description this should work: DELETE FROM repairs WHERE active=false AND repair_ID IN (SELECT repairID FROM repairtrade WHERE fieldID = 'cet')

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...