Report Format

[jereece]

I did a survey with about 20 questions and captured the answers in Access. I want to build a report where each page has the question in the heading and all the answers for that one question below that. Is there a way to build this in one report, or will I have to have 20 reports?

Thanks,
Jim

 

[rainman89]

If you base your report on a query, u will only have to design one report. But it should print out all records, so u would have 20 diff reports printed!

 

[boblarson]

Using the Sorting and Grouping, you can create a group for each question and then set the force new page property to have each group on separate sheets.

 

[jereece]

I appreciate the responses, but I am still a little confuse.

If I base the report on a query, I may only have to design one report, but I still would have to have 20 of them or change the query 20 times and rerun the report.

If I use Sorting and Grouping, I can group one all the responses for up to 3 heading, but those are tiered. I have 20 questions.

Just to make sure I am communicating what I want, heres a short example. My database structure looks something like this.

ID
Site
Question 1 Response
Question 2 Response
Question 3 Response

I want the report to look like this...

-----------------------
Page 1
Site | Question 1 Responses
-----------------------
Page 2
Site | Question 2 Responses
----------------------
Page 3
Site | Question 3 Responses
----------------------

 

[boblarson]

I'll throw together a little sample for you.

 

[boblarson]

Are the responses numeric, text, or possibly both?

 

[boblarson]

Check out the report in this sample. I know that most of everything here isn't going to be exactly as you are wanting, but maybe it will give you an idea on how to accomplish exactly what you want.

 

[jereece]

Check out the report in this sample. I know that most of everything here isn't going to be exactly as you are wanting, but maybe it will give you an idea on how to accomplish exactly what you want.

I appreciate your help Bob, but this is still not what I need. Your report shows the layout like this;

Site1
Question 1 Response
Question 2 Response
Question 3 Response

Site2
Question 1 Response
Question 2 Response
Question 3 Response

etc.... but what I want is for each page to be a question and below that all the answers (from all the sites) for that question. So each page of the report would have all the responses for that one question. So a page of the report might look like this.

What process do you use?
Site 1 - We use the A process
Site 2 - We use the B process
Site 3 - We use the Z process but want to start using the C process.

 

[boblarson]

Okay, I'll revise it to be closer. It'll take me a bit though as I am going to be away from the computer for a while. We have parent/teacher conferences tonight.

 

[jereece]

Okay, I'll revise it to be closer. It'll take me a bit though as I am going to be away from the computer for a while. We have parent/teacher conferences tonight.

Thank you. I really appreciate your help.

Jim

 

[boblarson]

Here you go. Hopefully this will get you closer to seeing how to do what you want.

 

[jereece]

Here you go. Hopefully this will get you closer to seeing how to do what you want.

The report is exactly what I am looking for. Now, how in the heck did you get it to do that? You don't have a query, just table and a report. I looked at the record source for the report, but don't have a clue how to write such a long string of code. Also, it appears your data is in 2-3 tables. I am simple minded so my data is all in one table. Can this be done with the data all in one table?

I really appreciate your efforts to help me.

Jim

 

[boblarson]

Actually, I do have a query. It is embedded in the recordsource of the report. You can write that easily enough because if you click in that property, you should see an elipsis (...) next to it. Then, if you click it you get the QBE grid where you can create a query just like you're used to. However, the difference is, that when you have it written, you don't click the save button, but just close the query window and then click the YES button. THEN you can click the save button.

It doesn't matter how many tables you use to get it like I did, but what you will need to do is to go to VIEW > SORTING AND GROUPING to see how I made it do what I did and what "Group Headers" I made appear.

 

[jereece]

Great! That's a big help. I really appreciate the support. I think I can do it now.

Jim