Counting Check Boxes or text boxes

C

Ced

I am creating a 27 question file audit. There is a yes or no answer to all 27
questions. I would like to have a total at the bottom of the page of how many
yes there are and how many no's. This form is also linked to an Access
database which keeps track of all the information.
 
S

S.Y.M. Wong-A-Ton

If your questions are in a group (which they probably are), you can use the
count() function with a filter to count the amount of yes and nos with
formulas like

count(Questions[@Answer = "True"])

and

count(Questions[@Answer = "False"])

These would go into actions for rules that set the values of the fields for
the totals at the bottom.
 

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