Counting Check Boxes or text boxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ced - 01 Feb 2006 01:01 GMT

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.

Reply to this Message

S.Y.M. Wong-A-Ton - 01 Feb 2006 09:30 GMT

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.

---
S.Y.M. Wong-A-Ton

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

Reply to this Message