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.