Count if

B

Bob

In my table I have a yes/no field and I want to send it
to a report and count how many yes's or no's in the report.
Is there a count if type function in building a report
like this.
 
D

Duane Hookom

Yes/No fields store values of -1/yes or 0/no so you can just sum the field
and find the absolute value
=Abs(Sum([YesNoField]))
or sum the No values
=Sum(YesNoField + 1)
 
Top