Multiple Fields Selection for One Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top