Count if

  • Thread starter Thread starter Bob
  • Start date Start date
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.
 
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)
 
Back
Top