Sum Mulitiple Sub-Report Amounts In The Main Report

[legalhustler]

I have a main report with a page header/footer and detail. In the detail section I have 9 sub reports. Each of the 9 subreports has a dollar amount and a count of transactions column. I would like to tally all my sub report amounts and number of transactions in the footer of my main report to come up with a Grand Total. I believe I would need to create a unbound textbox and create a formula. I need help on how to create the formula.

 

[legalhustler]

**bump**

 

[MexOkie]

Take a look at this, if you haven't already.

Summing in reports - Access

 

[legalhustler]

Can someone please help me?

I want to use the suggestion in the link below but, I really don't want my sub-reports to show totals (which is indicated in the very first step). I only want the main report to have a grand total of all the 10 sub reports [amounts] or the last line of the running sum report. I think getting the total of the last line of the running sum is trickerier and harder than just getting the total of each sub report [amount] field.

Each of my subreport looks something like this:

Subreport 1

Fiscal Quarter..........Amount...................Running Sum
Q1..........................$5...........................$5
Q2..........................$10..........................$15
Q3...........................$15.........................$30
Q4............................$20.........................$50

Subreport 2

Fiscal Quarter..........Amount...................Running Sum
Q1..........................$10...........................$10
Q2..........................$20..........................$30
Q3...........................$30.........................$60
Q4............................$40.........................$100

So, my main report should give a total of either each sub report [amount] field or the last line of the running sum amount, because they will eventually give the same result.

Any advice, tips, suggestions is much appreciated.

Microsoft Access tips: Bring the total from a subreport back onto the main report

 

[legalhustler]

Nevermind. I was able to resolve this issue. I set the total in the report footer in my subreport to Visible "No" so it does not show in my main report. Then I used the following formula in my unbound textbox (suggested by Allen Browne) to get a grand total of all sub-reports in my main report.

=IIf([Sub1].[Report].[HasData], Nz([Sub1].[Report].[txtTotal], 0), 0)+ IIf([Sub2].[Report].[HasData], Nz([Sub2].[Report].[txtTotal2], 0), 0).....etc