Counting entries in multiple fields

[AChir]

I have a form which gathers student choices (1,2,3 or 4) for each of 10 different questions. I want to know how many of each response there is for each of the questions so I can put this into a report. I want to get:
Question1 - 3 people answered 1, 4 answered 2...
Question2 - 5 answered 1 and so on

Is the only way to do this with multiple queries (one per question) or is there a quicker way? Thank you

 

[Travis]

I can see at least two ways to do this:

1. With a report set the Grouping on the Question and a Grouping on the Response field
In the Detail Section Place the Response Field but make its visible property False.

on the Header of the Response field add a text box and use the =Count([ResponseField]) to get the Count.

On the Footer of the Question Group add a text box and use =SUM(Count([ResponseField]) to get a total count of responses.


2. Use a Cross-Tab Query with the Question as the Row, Response as the Column and the Count of the Response as the Value.

 

[AChir]

Thanks, Travis - this doesn't quite fit what I have done but maybe my structure is poor here. I wanted to avoid a subform (for the sake of appearances) and so have a table with fields:
name (lookup from main participants list)
and then the successive question numbers so that students enter 1,2 3 or 4 as responses to the questions (multiple choice). Am I right in thinking I can't group by response in that case?

Thanks again