Multiple Unrelated Queries In One Report or Form?

[Richard Horne]

Hello guys,

I've been tasked with generating a report for my boss that provides an
overview of our core database statistics. This includes the total number of
orders placed each month and the total value of orders placed each month. I
also need to provide the same information for purchase orders, quotations and
discrepancy reports.

Each individual query is a piece of cake on its own but how can I display
all of this information either in a form or preferably in a nicely formatted
report?

The queries are all completely unrelated so there's no way I can somehow
join them all together.

I've managed to build a functioning form using lots of sub forms but it's
really annoying having to setup and configure one for each field/value I want
to display.

So my question is, what's the best way of doing this?

 

[Mark Andrews]

Why not just have one report which has no recordsource that has all the
subreports.
No linking of any kind between the main report and the subreports.

Each subreport then does it's own job (order stats, po stats, quotes,
etc...).

Each subreport would use the criteria from the form (such as month combobox
etc...)
that you click the "create report" button.

use the report header/footer in the sub reports, not page header/footer.

HTH,
Mark Andrews
RPT Software
http://www.rptsoftware.com