survey/questionairre

[Guest]

This is a bit complicated, but I'm not sure where to start with a
questionairre.
I have a 50-question questionairre that people circle set answers on, either
yes or no for each question.
Some questions are weighted to the 'yes' answer, and some are weighted to
the 'no'.
What I want to do is 'tell' Access which questions are weighted which way
and have it add up each individual's score after I enter their responses.
At present I'm manually counting them after I enter them because I'm not
sure how to make it count them.
My table looks lik:
Question 1 - Lookupcolumn "yes" "no"
Question 2 - Lookupcolumn "yes "no" etc etc.

 

[Douglas J Steele]

To see what a properly designed survey database should look like, take a
look at Duane Hookom's "At Your Survey".

You can find it at http://www.rogersaccesslibrary.com/OtherLibraries.asp

 

[Guest]

Thanks. I'm still working on it but that helped a lot.

 

[Guest]

Thanks. I'm still working on it but that helped a lot.