3 in 1 Reports

[Tekhelpnet]

Tricky task here.
I am recreating Report that containes 3 different sets of data coming from the same source.
1 Reports showing Past Transactions
2 Report showing Present transactions
3 Report showing Futire projected transactions
Each Report has different looks and amount of columns and totals - so those are pretty different Reports. They only related by pulling data from the same tables.

So I had created 3 different Queries that have 3 different filters.
I had created 3 different Reports.

Now I am setting up the Macro that suppose to run 3 queries and I am stuck!
I can open each Report but how do I get them to be as one?
I need to see pages continuation like if R1 has 2 and R2 has 1 and R3 has 2 - I need to see Page 1 of 5 etc.

I can't see how to make these 3 Reports as 1. Not yet anyway.
Thanks for ideas.

 

[randy700]

Perhaps a UNION query to combine the 3?


Randy

 

[MIKElaw]

Try using a sub-report. Might do the trick but it does depend how big they are

http://msdn2.microsoft.com/en-us/library/aa217618(office.11).aspx