Grouping comments by survey question

[roomdog]

I have a report being driven off of a query on a table of survey
responses:

Question 1 Q1 Comment
Q2 Q2Comment Q3............
Survey Response #1 2 Free text
3 Free text
Survey Response #2 3 Free text
5 Free text


In the report I'm trying to group the comments related to Q1 from all
the responses under a Q1 header, followed by the rest of the questions
and comments:


Question 1

Response 1 Comment
Response 2 Comment
Response 3 Comment

Question 2

Response 1 Comment
Resp;onse 2 Comment......

I've managed to get it to list the comments from response #1 in
sequence Q1-Qn, followed by small gap, then the comments from response
#2 in sequence Q1-Qn, but can't seem to get it to group the comments
by question rather than response.

Any help?

 

[Duane Hookom]

If you have separate fields for each question rather than separate records
for each question, you may need to use a union query to normalize your
response table.

If you can't figure this out, come back with your significant actual table
and field names.