Calculation using the option button

[petercummins]

Hi there guys,

I have set up a form that is going to be used as a survey.

I have 19 questions that need to be answered and have set up an option group for each question containing 5 option buttons in each.

Is there away to calculate a total score?

for example if all questions were answered using opt5 then the total in the textbox would appear '95'

Thanks for all your help!

 

[ColinEssex]

How many fields have you got in your table that holds the results?

Col

 

[petercummins]

19 fields (Q1, Q2, Q3 etc)

 

[ColinEssex]

Thought as much.

You need to have the fields vertically not horizontally. i.e. one line per answer

AnswerTableName

PersonID. . . . . . . QuestionNumber. . . . . . . . . . . Answer

12. . . . . . . . . . . . .2. . .. . . . . . . . . . . . . . . . . . a
45. . . . . . . . . . . . .12. . . . . . . . . . . . . . . . . . . . c
34. . . . . . . . . . . . . 2. . . . . . . . . . . . . . . . . . . . b

etc

Col

 

[petercummins]

not sure what you mean sorry Colin. Any chance of explaining it how you do that?

 

[ColinEssex]

Lets assume you have 20 people to do this survey.

Person 1 answers all 19 questions. So for every answer it is posted on a new line in the table. That way you can interrogate the answers much easier.

So for 20 people you have 20 x 19 = 380 rows in the table.

The trick is not to think of the table as a "spreadsheet" style - its a database, one answer per row per person. Plus you only have 3 fields in the table and you can have 100 questions if you like

Col

 

[petercummins]

Thanks for your replies Colin.

I understand what you mean but not sure how to go about doing it.

How do you set up the field vertically?

 

[rborob]

use the form design wizard and instead of tabular view use the other one (cant remember the name but it shows u examples)