Multi reports into one

[Dan @BCBS]

I was asked to create 1 report with the results from 4 different reports.
Each report was made from a seperate query. Ya, I know, good luck!!!
Without inventing a new query that does it all (aint going to happen) does
anyone have advise on moving values from multiple reports onto one new
report....
Open ended question I know... Any suggestions would help.

 

[Rick Brandt]

I was asked to create 1 report with the results from 4 different
reports. Each report was made from a seperate query. Ya, I know,
good luck!!! Without inventing a new query that does it all (aint
going to happen) does anyone have advise on moving values from
multiple reports onto one new report....
Open ended question I know... Any suggestions would help.

Place them all as subreports into an empty container report. You will have to
do something different about page headers and footers though. Page headers can
be replaced with a group header based on a constant (=1) and RepeatSection set
to true. There is no easy way to do that with page footers. If all you have in
the page footers is page numbers then you can do that in the container report.

 

[Dan @BCBS]

Don't mean to sound stupid, but what do you mean, SubReports and Empty
Containers.

The only "Sub" I know of is "SubForms" and "Empty Container" does that mean
blank report in in design????

Thanks

 

[Rick Brandt]

Don't mean to sound stupid, but what do you mean, SubReports and Empty
Containers.

The only "Sub" I know of is "SubForms" and "Empty Container" does
that mean blank report in in design????

In the same way that you can embed subforms inside parent forms you can embed
subreports inside parent reports. By empty container report I mean that the
parent report containing your subreports will have no Recordsource and no
content of its own. only your subreports. That is unless you want to use the
Report and/or Page Header/Footers for something.

 

[Dan @BCBS]

I've used Access many years and never created a subReport.
I Learn something everyday!!!!

Thanks