Formula to tally score on form

  • Thread starter Thread starter smeldawg
  • Start date Start date
S

smeldawg

Please help!

I have created a form that contains 16 questions that the user uses an
option group to select from 3 choices. I want to create a weighted scoring
system to grade the evaluation. Question 1 may be 5% of the weight and
Question 2 15%. If the first option is selected, they get all of the points,
if the second is selected they receive no points and if the third is selected
the question should be removed from the equation. I currently have the values
of option one as the total points for the question, option 2 is zero and
option three is -1.

Is there an expression that can score all of the questions and omit any
questions where option 3 is selected?

The control sources are named [CAQ1], [CAQ2], etc.

Any help would be much apprecited.
 
You said nothing of your table structure or query for the form.

Do you use a single record for an individual and all 16 questions?

You might want to search out an existing template for surveys.
 
Back
Top