Answer Summary

[Madapple]

I have a survey that has 191 questions - each question has 10 possible answers - each group of 10 possible answers are different for each question.

I have the list of possible answers so having a db of each answer - paired to each question is not a problem

But what I would like is a way to see each answers total for each question

so for "Best Local Band" band a) 100 band 5 Band c) 200 band d) 30 etc...

for each of the 191 questions.

what do I need to do??

[dreamingmind]

hmm...

I'm thinking your master answer list has id field;

when a user picks that answer you record the answer id in a record for them;

then the master answer list looks at the user selected answers table (id=id relationship) and counts how many times it's own id shows up.

put that count in a field in the master question record.

Don