Sum of Yes, No boxes

  • Thread starter Thread starter Jenn
  • Start date Start date
J

Jenn

I am trying to add up the total of boxes that are checked
yes, in a report. And it's not working. I get the total
for the boxes that are not checked. Any idea's?
 
Jenn

Yes no fields have a value of 0 or -1, the later if true, the previous if
false. So in the report or group footer control where you want the total
of the yeses, simply create an unbound control with the control source like
this: = ABS(Sum([MyYesNoField]) which would give you the absolute value
of the yes, i.e. a positive sum.

HTH
 
Back
Top