Query to display two check boxed fields regardless of whether one of them is true.

[gumby]

I have a table with two check box fields and I would like to run a
query that reports the records that have atleast one of the fields as
False. When I put false in for both fields I get only the fields that
are both false. Unless they are all true, then I want that record to
return.

Thanks,
David

 

[guido via AccessMonster.com]

You have to put "False" in different criteria rows, not accross the same one.
Then you will get the "Or" you need.

 

[gumby]

Thank you.