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

  • Thread starter Thread starter Jose Cortez
  • Start date Start date
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.
 
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
 
Back
Top