Results 1 to 5 of 5

Thread: Query Question

  1. #1
    Join Date
    Dec 2003
    Posts
    138

    Question Unanswered: Query Question

    I have a subquery in which I have combined the answers to two or more fields that are checkboxes. I need to see only the ones that are not Null. I tried the Is Not Null command and it did not work. Any suggestions?

    Let me give you a little more background:

    My main table consists of nothing but checkboxes and a few text boxes. In order to print my report and make it more user friendly, I had to make a subquery that would make the checkboxes show abbreviations in the report. No problem, did that. My problem now is, I have a field (Restraints) that combines several other fields; i.e. 2 (2-person), 3 (3-person), SH (Standing Hold), SC (Small Child). If this Restraint field is left empty, I don't want to see the record. I need to tally all of the restraints for the month.

  2. #2
    Join Date
    Jul 2003
    Location
    Earth | North America | United States | California | Long Beach
    Posts
    62
    Checkboxes would most likely be selected as TRUE/FALSE instead of Null and Not Null

    Jack

  3. #3
    Join Date
    Dec 2003
    Posts
    138
    Originally posted by Jaash
    Checkboxes would most likely be selected as TRUE/FALSE instead of Null and Not Null

    Jack
    Does that count even though the field that I am trying to use the null value is text now and not checkboxes? If so, how would I type that in the criteria?

  4. #4
    Join Date
    Jul 2003
    Location
    Earth | North America | United States | California | Long Beach
    Posts
    62
    Originally posted by dendalee
    Does that count even though the field that I am trying to use the null value is text now and not checkboxes? If so, how would I type that in the criteria?
    That depends on how you are concatenating the fields together.

    It sounds like you are including spaces in your concatenation. This would make all of the resulting fields Not Null.

    You should try to select your records prior to the concatenation. In the Cruiteria line in the query you should put TRUE (to select checked boxes) or FALSE (to select boxes that are not checked).

    hth

    Jack

  5. #5
    Join Date
    Dec 2003
    Posts
    138
    I got it to work with:

    <>""

    It was not recognizing the null fields so I had it get rid of the ones that were empty. Period. Thanks alot for your help anyway! Greatly appreciated. I love this forum!! It really gets me thinking.

    Dendalee

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •