Group fields onto one page, for many fields

[MediaDoc]

Hello, this should be easy for me to figure out, but I must be having lapse of Access IQ...

I have a table with multiple memo fields (comments from people).

I want to print all the comments for Question 1, then for Question 2, the for Question 3.

So group for each field, across records... to look like.

Comments From Question 1

blah blah blah (record 1)

blah blah blah (record 2)

blah blah blah (record 3)

Comments From Question 2

blah blah blah (record 1)

blah blah blah (record 2)

blah blah blah (record 3)


There are a total of 23 Questions... the grouping and sorting only allow 10 -- not that that worked anyways..

Help!

Matts

 

[yippie_ky_yay]

Hey Matts,

sounds like you have design issues. I am envisioning at least 3 tables in your database.

Table_Person
PersonID
Name
etc

Table_Question
Q_ID
Actual_Question

Table_Answers
PersonID
Q_ID
Answer


Table_Answers is what joins everything together. Then, when you create your report, you only need to group by Q_ID.

If all of your stuff is in one table, let me know before you start cutting and pasting away - we may be able to save a lot of time.

-Sean