Current month and YTD in same query

[thart21]

I cannot seem to find a solution to this.

I have one table with a MonthID in the format of 104 for January, 2004 and so on. I need to create a report in which the left side shows data for the current month grouped by Supplier and the right side shows data for the entire project term, which goes back as far as 2002. I have created a Monthly totals query and a Project totals query which both work, but don't understand how to put them together in another query to create the final report. Any ideas would be appreciated.

Thanks,

Toni

 

[dcx693]

Why put them into the same report using one query? Why not use your report to contain 2 subreports? Each being fed by one of your queries?

 

[thart21]

Thank you! I've worked with subforms but this is my first report like this-didn't even think about two subreports, it worked perfectly!

Toni

 

[dcx693]

Cool. I'd never done it myself either, but it should've worked in theory.