• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 216
  • Last Modified:

And/or clause in querry

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))
0
cansevin
Asked:
cansevin
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
If these are true yes/no fields, you want to use true and false, so it would be:

WHERE Bookings.CheckPay = True OR Bookings.ChargeWeekBefore = True

Jim.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now