Unanswered: count based on multiple criteria & records
Need help with this one.
I have an online survey with 20 question, they each have 4 options. I need to display in a table the count of each option chosen per question.
e.g. q1: 6 people selected 1, 2 selected 2, 8 select 3 and 10 selected 4.
I am using asp and an access db.
Can anyone suggest the best way to go about this? do I put all records from the db into an array then count occurances and store in another array?(4X20, 80 results to display in a table - Doh) or can I use sql? combination of both? query built into db?....I dunno