option 1 of a question is a 3, and option 3 is a 1

J

Jose Cortez

i am working with a questionaire which have 36 question with each question
having 5 options. so if a client chooses question #12 option 1, the option 1
is actually a value of 3, and if they choose option 3 this option is actually
a value of 1. so in other words, 1 is a 3 and 3 is a 1. can someone help me
out with this. or give me an idea of what to do. thank you.
 
D

Douglas J. Steele

What are the other options worth?

If it's a straight forward mapping that's the same for each question, create
a function that accepts the option as input and returns a score.

Another approach would be to have a table containing the mappings from
answers to points.

I should probably mention foremost that you should NOT have 36 fields in the
table, one per question. Each question should be a separate row. See Duane
Hookom's "At Your Survey" for proper design
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

between question, question 1 is a 3, question 3 is a 1 1
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Adding sequence numbers to paragraphs 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Section and Page numbering 0
Need some PWA help 0
Custom Number sequences 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0

Top