Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006
    Posts
    7

    Pull only if a specified value does not exist

    I have a table where there is a checkbox for "Enrollment" and then a second field with a month. What should my query look like if I want to pull all records out where the checkbox is true but the month specified doesn't exist in the record.



    Example Table (looking for the second field to be true but no July record):

    Account | True | June
    Account | True | July
    Account2 | True | July
    Account3 | False| null
    Account4 |True | null

    "Account" has a July record so this record should not pull
    "Account2" has a July record so this record should not pull
    "Account 3" is False so should not pull
    "Account 4" is true and has no July - so this record should pull

    Thanks in advance!

  2. #2
    wasim_sono is offline Advanced Beginner
    Windows XP Access 2013 64bit
    Join Date
    May 2005
    Location
    Pakistan
    Posts
    73
    Dear hraup

    You have to simply write down "Is Null" in month criteria and "true" in Account criteria.


    Thanks.

    Wasim

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

Similar Threads

  1. Pull Data from another table
    By bbranco in forum Access
    Replies: 1
    Last Post: 06-19-2013, 06:15 AM
  2. Replies: 2
    Last Post: 05-08-2013, 03:37 AM
  3. Replies: 1
    Last Post: 02-14-2007, 07:27 PM
  4. Pull Parameter Value from Form
    By dymondjack in forum Queries
    Replies: 1
    Last Post: 02-14-2007, 07:15 PM
  5. Replies: 0
    Last Post: 12-19-2006, 09:44 PM

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