Results 1 to 4 of 4
  1. #1
    patchesohouli is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2016
    Posts
    17

    Delete from Query B where record exists in Query A

    Hi,


    I have two queries, Exception Report Employees with Different Frequencies and Biweekly. If employees populate on the Exceptions Report, I want them to be deleted from the Biweekly query. We could use the field “Empl ID” to find matches.

    Is there an easy way to do this?

    Thanks

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Just do an Unmatched Query between the two.
    Access actually has a "Find Unmatched Query Wizard" which will walk you though it.
    If the Biweekly query is based on just one table, you can actually design this query using the original table and your Exceptions Report Employees query.

  3. #3
    patchesohouli is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2016
    Posts
    17
    That worked! Thanks!

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    You are welcome. A few of those Query Wizards they have are quite handy, especially if you are fairly new to Access.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 08-26-2015, 12:58 AM
  2. deleted record error after delete query
    By ck4794 in forum Queries
    Replies: 3
    Last Post: 10-12-2013, 02:04 PM
  3. Replies: 3
    Last Post: 10-19-2012, 04:30 PM
  4. Trying to Delete record using delete query
    By MooseOTL in forum Access
    Replies: 13
    Last Post: 10-04-2011, 02:30 AM
  5. if record exists...conditional query criteria
    By mbryanr in forum Queries
    Replies: 2
    Last Post: 02-12-2010, 11:50 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums