I am trying to make a query that counts any check mark that is "Yes". The field name is "CheckPay", if that is checked on... then I want the query to count it.
I am guessing I need to build an expression that says YesField: "If CheckPay is Yes, count it".
Not sure how to write that expression. I am building the query in the design sections. Not the sql. Thanks!