I created a form w/ 16 questions from a table where fields Q1-Q16 reside they are stup as text fields.
I used the “option group function” and labled for each question choices 1 through 5.
And gave each a value of 1-5 using check boxes, these values are then stored in the Q1-Q16 fields.
What I would like to do is total the answers & calculate the percentage of answers from the 16 questions.
I.E., Q1,Q7,Q10 has value of 2. Q2,Q3 & Q5 have a value of 3.
How do I get access to show (& where?) what percent of the 16 has a value of 1, 2, 3, 4, 5?
