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