Multiple-question survey

Thanks to both of you. It was too simple for me to see.




"jsteinmann" <webforumsuser@macromedia.com> wrote in message
news:f1ebm8$jv0$1@forums.macromedia.com...
> Easy to do. If your answers are yes and no, simply assign a value to the
> correct answer. For example, a correct answer = 1 and a wrong answer = 0.
> If
> you have 10 questions, 10 is a perfect score. Have the form add the
> results
> and send to a results page. So if you had, for example, 8 points, you can
> change it to a percentage. Unless you want to store the results, you
> don't
> have to use the database either. You were going to create 57 recordsets?
> Keep
> it simple.
>

Easy to do. If your answers are yes and no, simply assign a value to the correct answer. For example, a correct answer = 1 and a wrong answer = 0. If you have 10 questions, 10 is a perfect score. Have the form add the results and send to a results page. So if you had, for example, 8 points, you can change it to a percentage. Unless you want to store the results, you don't have to use the database either.

Maybe this article will help give you some ideas
http://nlecommerce1.dcccd.edu/pages/250.asp

I think you need a table for questions and a table for answers. The answers table would probably have columns like: RespondantID, QuestionID and Answer. I would store the answers as a single byte 1 for yes 2 for no, 3 for N/A etc. It's then relatively easy to write the SQL to pick out the % of each.