I have two reports one for Monthly expenses and the other for Year to date expenses. I want to combine the two as shown below:
- - - - - - - - - - - - - - - - - -
Page Header:
Monthly YTD
Expenses Expenses
- - - - - - - - - - - - - - - - - -
GroupHeader0
=[Expense] =Sum([SumOfExpense])
- - - - - - - - - - - - - - - - - -
GroupFooter1
="Summary for " & "'Subcode' = " & " " & [Subcode] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"
- - - - - - - - - - - - - - - - - -
Report Footer
=Sum([Expense]) =Sum([SumOfExpense])
- - - - - - - - - - - - - - - - - -
Running the reports separately:
for the monthly expense I enter a parameter value (i.e. December)
for the year to date expense its run and sort by Date processed(Between #7/1/2003# And #6/30/2004#)

My problem start when I try to combine the two reports I get that same numbers. If I take out one of the report footer I get the right number for that column and same is true the other way around.

Hope this make sense.

Many thanks in advance to all who can help me with this.