AND Operator.

[Guest]

I have a query which I want to filter out records according to two boolean values. How do make it so that it only shows the records when both fields are equal to no?

At the moment it doesn't display the records if either of them say no, I want it to only apply if both fields say no.

 

[Ted Allen]

Hi Richard,

If you are using the query builder you can specify AND
conditions by placing the multiple criteria on the same
criteria row. Criteria placed on separate rows are
evaluated using the OR condition. So, you should be able
to get what you want by placing <>True under both of the
fields on the same criteria row.

HTH, Ted Allen

-----Original Message-----
I have a query which I want to filter out records

according to two boolean values. How do make it so that
it only shows the records when both fields are equal to
no?

At the moment it doesn't display the records if either

of them say no, I want it to only apply if both fields
say no.