Please help me out of a jam (Counting duplicates) (1 Viewer)

[murpm3]

Ok here is my problem that I need some help on:

I have some survey data....I need to produce reports based on how many people had chosen a given answer.

The answers were based on a "1-7" scale. I have 13 Questions...Each in a different field. In those fields the data is like I said, a single number from 1-7.

Anyways, how do I specifically count the number of 1s, 2s, 3s, 4s etc...

I want my report to look something like this:


Q1 Q2 Q3

1 35 45 24
2 12 25 44
3 2 9 25

So that is how it should look....Question names on top, and on the left the corresponding answer they picked. I can figure out how to format the information.

But what do I have to do to come up with those totals....How do I count the total number of 1s etc....

Thank you so much for your help.

 

[DBL]

You need to use a Crosstab query. The query wizard will take you through the steps. Your question numbers will be the column headers, the ranges will be the row headers and the responses will be your value - set that to count.