Questionairre Table Design

[Debased]

Need Help on Table/Form Design

I have a data input form with 32 questions each worth 10 points,. The answer is selected in a combo box with choices “Yes”, “No” or “N/A” (not applicable). Once the form is completed the following formula is used to compute the percentage score: count(yes) / 320 – count(na).

Does this sound like the best way to go about it?

At first I thought about assigning number values 1= yes and 0= no but got stuck on what to assign to "N/A" so that the calculation will work.

Check boxes are also a possibility.

Any suggestions for this Monday dimwit!!

 

[RichO]

Are you simply wanting the yes and N/A responses counted as the questions are answered (not saved in the table) and then the percentage calculated at the end?

Is this a form of a quiz where there is a correct answer for every question?

Something like this is very simple but I'll wait for your answer before I continue...

 

[Mile-O]

I wouldn't hard code in the total score as circumstances can change.

i.e.

tblQuestion
QuestionID
Question
Points