I have a table with 30 fields, each is field a measurement of performance (timeliness, helpfulness, etc). The values in this field are 0 ,1 or 2. There is also a formID field cooresponding to each entry. Looks like this:
FormID Timeliness Helpfulness
224 0 2
384 1 0
What I need is to count the vaules, grouped by the fields, but I can't seem to design the right crosstab query (I'm assuming that's what I need). Here's what I want:
Question 0 1 2
Timeliness 40 62 22
Helpfulness 88 21 33
Is this even possible?
Thanks in advance!
FormID Timeliness Helpfulness
224 0 2
384 1 0
What I need is to count the vaules, grouped by the fields, but I can't seem to design the right crosstab query (I'm assuming that's what I need). Here's what I want:
Question 0 1 2
Timeliness 40 62 22
Helpfulness 88 21 33
Is this even possible?
Thanks in advance!
