Multiple Fields 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
 
S

Smartin

Queryconfused said:
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
Click to expand...

Are you writing a new query or trying to set up an in-place filter
whilst viewing the table/query result?

It seems like the latter. If this is the case, use the "filter by form"
tool. Select your criterion on one field and notice the "OR" tab at
the bottom of the window becomes available. Click the "OR" tab, select a
criterion on another field. Continue adding "OR" conditions as necessary
before applying the filter.

Hope this helps!
 
Top