calculate a test score

[ad2]

If someone could point me to an example I would be grateful.

What I have is a form with 8 questions, all yes/no. Q. 1-3 are worth 1 point, Q. 4-5 are worth 2 points, Q. 6-8 are worth 3 points. User scores the points when they answer yes to a question, 0 points if they answer no.

What I need is code that will calculate the total score and put the result in a text box Result?

As well as storing the Result, I would like the user to see their score after Q.8 is answered, so I’m trying to figure out an automated score function.

Thanks in advance.

 

[SkipVought]

Hi,

I'd create a TestValues table and then join the two on QuestionNbr.

Skip,

_[red][/red]