Option Groups options counted

[Steve G]

I have a Personnel form that I am trying to automate.
(evaluation values 5 thru 1)
5 4 3 2 1
"evaluation statement" (option group using check boxes)
"evaluation statement" (option group using check boxes)
total x 0 x 0 0

My question concerns how to find the total number of same evaluation values
checked for each this section.

thanks!

 

[Marshall Barton]

I have a Personnel form that I am trying to automate.
(evaluation values 5 thru 1)
5 4 3 2 1
"evaluation statement" (option group using check boxes)
"evaluation statement" (option group using check boxes)
total x 0 x 0 0

My question concerns how to find the total number of same evaluation values
checked for each this section.

A form is just a presentation of the data in a table. How
you would calculate the totals depends on how your table(s?)
are designed.

I suspect that in this case, you have one field for the
option group and the field values are 1 or 2 or ... or Null
(when no check box is selected). Then you have a separate
record in the table for each evaluation statement. In this
case the form/report footer section can calculate each one
of the totals using an expression like:
=Abs(Sum(thefield = 5))

and the total number of evaluations where any box was
checked: =Count(thefield)