August 13, 200718 yr 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??
August 13, 200718 yr 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
Create an account or sign in to comment