Grouping comments by survey question

  • Thread starter Thread starter roomdog
  • Start date Start date
R

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?
 
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.
 
Back
Top