Multiple Fields Selection for One Query

Q

Queryconfused

Hi,

I am trying to select multiple Yes/No fields with each filter interdependent
of one another. What is happening is once it filters the first yes/no column,
the remainder base it upon the results.

Can anyone provide assistance?

Thanks.

G
 
A

Allen Browne

What do you actually want?

If you want to return records where any one of the columns is checked, then
use different *rows* under the Criteria in query design.

You will end up with something like this:
Criteria True
Or True
Or True

If you have many yes/no columns, you probably have a non-nomalized design.
 
Top