And/or clause in querry
Posted on 2014-03-22
I am using the below "WHERE" clause. I would the querry to show any result where either one is "Yes", they both don't have be "Yes"... if one or the other is "Yes" then I would like it so show the query. Any idea how I write that?
WHERE (((Bookings.CheckPay)=Yes) AND ((Bookings.ChargeWeekBefore)=Yes))