Sum on a report for check boxes

[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?

 

[Duane Hookom]

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.