Select Multiple Fields

  • 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
 
Do you want EITHER (yes/no) field condition be true (be yes)? change the
AND conjunction to OR (in SQL view):


.... WHERE f1='yes' OR f2='yes'



Note that if the field is Boolean, not a string, the required syntax is
probably

.... WHERE f1 <> 0 OR f2 <> 0



or just


..... WHERE f1 OR f2




Hoping it may help,
Vanderghast, Access MVP
 
Back
Top