sum a subreport and display in main report

[sunflower]

I have a report grouped by month...
how do I sum [TotalExpense] in a subreport
and display it in the main report [TotalMonthExpense]

I have a text box [TotalMonthExpense]
in the group footer with control source
=[subrptJobExpense]![TotalExpense]

When I run the report the [TotalMonthExpense] is blank

Any help is appreciated

 

[Allen Browne]

You probably need to place a text box into the Report Footer section of your
subreport, so you get a total for the entire subreport.

Then for the tricks to transfer the total to the main report, see:
Bring the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

 

[sunflower]

That worked perfectly...Thanks so much!

You probably need to place a text box into the Report Footer section of
your subreport, so you get a total for the entire subreport.

Then for the tricks to transfer the total to the main report, see:
Bring the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a report grouped by month...
how do I sum [TotalExpense] in a subreport
and display it in the main report [TotalMonthExpense]

I have a text box [TotalMonthExpense]
in the group footer with control source
=[subrptJobExpense]![TotalExpense]

When I run the report the [TotalMonthExpense] is blank