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

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
 
M

Marshall Barton

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.

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
. . .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top