Query Question

[shoelesscraig]

Hopefully this question makes sense. I have a table with 3 fields that are checkboxes (yes or no). We can call them C1, C2 and C3. Then I have a form from which I would like to run a query. On that form, there are 3 checkboxes, call them C1Test, C2Test, and C3Test. Basically, I'd like to check any combination of these 3 "test" checkboxes and then run the query and the query return me the records in the table where that combo exists.

I can get close, but no cigar. If I only check C1Test, I want it to return records where C1 is Yes. (Same thing with C2 and C3). However, If I check C1Test AND C2Test, I'd like it to return records where C1 is Yes and records where C2 is Yes.....NOTE:: I don't want it to ONLY return records where BOTH are Yes....I literally want all records where EITHER C1 or C2 are Yes.

Make any sense at all?

[June7]

Did you try OR operator?

[John_G]

You can't simply test for equality (C1 = C1Test), because you will get records where both are False as well. You will need to use somthing like (C1Test And C1 = C1Test), and have one of those expressions for each checkbox, something like this:

(C1Test And C1 = C1Test) OR (C2Test And C2 = C2Test) OR (C3Test And C3 = C3Test)

Note the use of the parentheses!