Sum on a report for check boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a database for tracking employee performance based on work orders
pass or fail. Pass and fail are check boxes on the table and I need to sum.
After each employee man number on my report I want to total the # of
inspections, # of pass, # of fail and fail rate. How can I accomplish this
particularly with the check boxes?
 
To count the number of checked boxes, use an expression like:
=Sum( Abs( YesNoField ) )
You can use this in a group or report header or footer.
 
Back
Top