How to create one report from two queries

[tanyapeila]

I have two queries pulling from two tables
One is Outbound shippers, one is Inbound Shippers. They are joined by a Yes/No field, the Yes/No field =True.
I can get the queries and the reports to run independently but I cannot get the report or a query to pull anything together.
Does that make sense?

[JoeM]

Take a look at Subreports.
http://office.microsoft.com/en-us/ac...010209281.aspx

[tanyapeila]

Thank you JoeM. Now I have both report on one report how do I add the totals from both reports into the main report.
Here is the formula I have now in the Page footer:
=Sum([Inbound Linehaul Query subreport].[Report]![NET Weight]+[OUTBOUND Linehaul Query subreport].[Report]![NET])

[tanyapeila]

I got it!
=[Inbound Linehaul Query subreport].[Report]![NET Weight]+[OUTBOUND Linehaul Query subreport].[Report]![NET]

[JoeM]

I think it makes more sense to put it in the Report Footer than the Page Footer.
There is also a MS article on this topic: http://support.microsoft.com/kb/208835