calculation in a report

  • Thread starter Thread starter Fipp
  • Start date Start date
F

Fipp

In my "stats" report I am trying to calculate the count
of the yes/no field "turnin" of those records where the
value = yes.

I am sure there is an easy expression or function but I
can't figure it out. Any help is greatly appreciated.

Fipp
 
Try a control source of:
= - Sum([turnin])

True is -1. False is 0. Sum the field. Negate the result.
 
Back
Top