count true in footer

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

hi and thank you for taking the time to answer my
question.
i have a report that has our staff records for the last 10
years. in the report there is a check box (staff active)
for each staff member if its checked (true) it means they
are currently an active staff member.
here is my question
in the footer i want a sum of the active staff only (true)
i tried =count([staff active])
but its counting all the records
what do i need to do to count only the staff that the
check box is true.
thanks
brad
 
Hello Brad


The value of a checked tick box is -1

So you count them in the footer, but only if the values
are -1

the calculated field should read "=Count(iif([Staff Active]
=-1,0))
That should pick up you actives

Your inactives would be found on a Zero(0)

Regards

Jim Normile
 
Back
Top