Yes/No

[monbri]

I have a combo box (Yes/No) in my dataentry form and I need the report to count how many Yes's I have.

When I try the Count formula it counts both the no's and the yes's

Any suggestions.

Thanks in advance

 

[Corticus]

Hi monbri, welcome to the board!

If you add an expression to your query like:
TrueCount: Count([myField]=True)
(make sure you change the 'total' field from group by to expression.

Depending on how you group this aggregate query, each group will have a new field that counts the total number of 'true's in the specified field. If you need all the 'true's, remove all the fields from your aggregate query so there is nothing to group on but the count of 'true's.

Hope this helps,