Query to group multiple choice answers

[edluke]

i have got a table which contains data read in from a software package that reads fill-in bubble answer sheets.

the table looks like this

classID---Question1---Question2---Question3---Question4
1 B A D B
1 C C C A
2 B D A A
2 A A C D

I need to create a query that will count the instances of each response and group by classID, one Class at a time

So the output of the query would look like this

classID---Response---Question1---Q2---Q3---Q4
1 A 1 2 1 2
1 B 2 0 0 1
1 C 1 1 2 0
1 D 0 1 1 1

i'm sure i can do it question by question, but there must be an easier way.

thanx in advance

 

[mymou]

Hi edluke

Have you checked out Crosstab queries?

Stew