Multiple Queries into a Report

[naviTara]

hello,

I have 4 queries that I need to get into a Summary report. I am having an issue compiling that much data into a report. Any insights??

Thank you for your consideration.

 

[scriverb]

Try using SubReports for each of the four queries. I take it that they are somewhat unrelated and that is the reason they are in seperate queries.

If I am way off here please post back with a more detail explanation of the data and what you want to display.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[Ed2020]

If all the queries return the same fields then use a Union query to return all the data from each of the queries. Base the report on the Union query.

Ed Metcalfe.

Please do not feed the trolls.....

 

[naviTara]

Thank you both Ed2020 and scriverb.

Here is detail of what I need to do:

Basically, there was a Excel report created containing 8 tabs, derived from four different queries. In addition, two of the queries will need to have sections that can be SUM based on a monthly date range.

Currently, this report is produced manually and exported to Excel. I have been asked to create a report or a way that would incorporate these and would allow an non-Access savvy indivudual to simply run a report.

Again, any insight would be much appreciated.

Thank you again.