Multiple Queries in a single report

[tpendergast]

I have 27 different queries that extract different information from a multiple table database. I need to create a way to present the information in a report format. Some of the queries break the user information down into age and economic status. The report needs to be in a structured format that presents all on the information in a 1 - 2 page summary. How should I accomplish this?

Thanks for the help!!!

 

[tpendergast]

I have figured out that I can present the data in Excel in the format that I need it. Is there a way to do this in Access?

 

[dhookom]

You can create subreports from each query and place the subreports on a main report.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[hceonetman]

I had to make Access re-create a report where I couldn't modify the report design. What worked for me was to create a table that had all the fields needed on the report. I then used a VBA module to collect the data and fill fields in a new record in the table. I then ran the report directly from the table, then deleted the record. Seems a long way around but you have complete control of the data, and the report tools in Access can be limiting.
HCEONETMAN

 

[hjgoldstein]

How about creating a single query from the 27 you have using the data you need in the report and then develop the report from this 28th query?