Report All Answers From A Field - One By One

[kb178]

I hope this makes sense to someone out there....

Someone had me put together a small access database for a survey they had given. Some of the data is long winded, but he wants to see what the answers to these questions look like - to see if it could be summarized. With that he'd like a report and see something like this:
Question 1:
Answer 1
Answer 2
Answer 3
...
Answer 20

Question 2:
Answer 1
Answer 2
Answer 3
...
Answer 20

Question 3:
...

Is it possible to make a report look like that when the table has fields like this?
ID Q1 Q2 Q3

Thanks!

 

[indyaries]

Hi KB178,

I made a quick database;
t_Questions / QuestionID (Autonumber) / Question (Text 255)
t_Answers / AnswerID (Autonumber) / QuestionID (Number Long Integer) / Answer (Text 255)

In Relationships I joined t_Questions-QuestionID to t_Answers-QuestionID in a One to Many.

Created a query with both tables

Created Form and Subform for the Survey

Created Report using Report Wizard;
1. Base report on query
2. Include fields of your choice
3. View data by t_Questions
4. Group by Answer
5. Use Stepped format - Landscape view.

This will show your report with the question, question number, and answers grouped below the question.

Hope this helps,

Bob
aries170@comcast.net
robert.cole@dfas.mil