Query Criteria Question

After re-reading I think I may understand what you need.

Is this correct? You only want to display records if one of the two yes/no fields are True. And, you don't want to display the records wherein both fields are false. Correct?

I understand you have a table that contains 2 Yes/No fields. Some records have at least one field set to True. However, there are some records wherein both fields are set to false. You don't want to display records where both fields are false.

Bring the table into a query. In the first criteria row, set one field to display if True, and the other to display if False.

Then, using the next row of criteria (the "or:" criteria), do the reverse. Set the first field to False and the second field to True.

So you're telling the query to
1) show records where Field1 is True and Field2 is False
OR 2) show records where Field1 is False and Field2 is True.

That should get you what you need. (Unless I'm misunderstanding your question).

https://preview.redd.it/89w3idkgst2a1.png?width=391&format=png&auto=webp&s=96f8aaa59307309c4fdd4e7aea929456be2203b4

/r/MSAccess Thread