AND Operator.

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

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.
 
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
Click to expand...
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
Click to expand...
of them say no, I want it to only apply if both fields
say no.
 
Back
Top