Multiple Unrelated Queries In One Report or Form?

[Richard Horne]

Hey guys,

I posted this question earlier but it doesn't seem to have appeared in the
forum for whatever reason so I'm having to repost.

I'm trying to generate a report for my boss that shows the number of orders
placed for each month over the past year as well as the value of those
orders. However, I also need to show to number and value of purchase orders,
quotes, enquiries and discrepancy reports.

The individual queries are all straight forward and they're not what's
taxing me. The problem is that they are all unrelated and I don't know how to
get all of them into one single report.

Is this even possible, and if so how do I go about it?

Thanks in advance.

 

[Dale Fye]

Well, it sounds like they are related by month. So, one way to approach
this would be:

1. Create a query that returns nothing but the months of the year you want
the report for. Use this query as the RecordSource for the main report.

2. Create separate sub-reports for each of the areas (orders, Purchace
Orders, Quotes, Enquiries, and discrepancies. Making sure that the query for
each of these sub-reports has a field for Year/Month, which can map to the
Year/Month field in the main report.

3. Then, in the main report, set it up to Group by the Year/Month, and add
each of the subreports from #2 into the details section of the main report.
As you add each one, make sure you set the Master/Child relationship to the
Year/Month field in the main and each sub-report.


Another way to approach it, if all you are generating for each of the
queries is a set of Year/Month and numbers of orders, purchase orders,
quotes, enquiries, and discrepancies. If this is what each of the queries
does, you could merge them in a union query and then do a cross-tab to get
column headers of "Orders", "PO's",
"Enquiries", "Quotes", and "Discrepancies" and row headers of the Year/Month.