How can I just count the records where the check boxes are "No"

  • Thread starter Thread starter Julie Gilliam
  • Start date Start date
J

Julie Gilliam

I have a audit form and when something is not completed then it is not
checked. I need to have a total at the end of each item to count how many
records are out of compliance. Please HELP need by this afternoon
 
I have a audit form and when something is not completed then it is not
checked. I need to have a total at the end of each item to count how many
records are out of compliance.
Click to expand...

Use a text box with an expression like any of:
=Count(IIf([check field], Null, 0))
or
=Sum(IIf([check field], 0, 1))
or
=-Sum(Not [check field])
or
=Abs(Sum(Not [check field]))
or
. . .
 
Back
Top