Prev: Data changes when exporting a report to Excel
Next: Changes to "Issues" Template
From: znibk on 13 May 2010 14:02
I have four categories of income. Each category totals itself in the Income
Type Footer, however, when I try to add each in the Bank Footer, I am asked
for the various parameters I have named my text boxes.

In the IncomeType Footer, I have:
=Sum[SalesDep]
=Sum[CashDep]
=Sum[OtherIncDep]
=Sum[OtherSalesDep]

In the Bank Footer, I created four txt boxes. The names of each, the control
source, and running sum are:
Name: SalesDepRS
Control Source: =Sum[SalesDep]
Running Sum: Over Group

Name: CashDepRS
Control Source: =Sum[CashDep]
Running Sum: Over Group

Name: OtherIncDepRS
Control Source: =Sum[OtherIncDep]
Running Sum: Over Group

Name: OtherSalesDepRS
Control Source: =Sum[OtherSalesDep]
Running Sum: Over Group

I then have a text box in which I want the total to appear and it is:

Name: Total [Bank] Income:
Control: =Sum([ASalesDepRS]+[AOIDepRS]+[AOSDepRS]+[ACDDepRS])
Running Sum: Over All

When I run the report, I am prompted for each of the *RS parameters and do
not get a Total Over All for each bank. Please help me get it correct.



From: Marshall Barton on 13 May 2010 14:49
znibk wrote:

>I have four categories of income. Each category totals itself in the Income
>Type Footer, however, when I try to add each in the Bank Footer, I am asked
>for the various parameters I have named my text boxes.
>
>In the IncomeType Footer, I have:
>=Sum[SalesDep]
>=Sum[CashDep]
>=Sum[OtherIncDep]
>=Sum[OtherSalesDep]
>
>In the Bank Footer, I created four txt boxes. The names of each, the control
>source, and running sum are:
>Name: SalesDepRS
>Control Source: =Sum[SalesDep]
>Running Sum: Over Group
>
>Name: CashDepRS
>Control Source: =Sum[CashDep]
>Running Sum: Over Group
>
>Name: OtherIncDepRS
>Control Source: =Sum[OtherIncDep]
>Running Sum: Over Group
>
>Name: OtherSalesDepRS
>Control Source: =Sum[OtherSalesDep]
>Running Sum: Over Group
>
>I then have a text box in which I want the total to appear and it is:
>
>Name: Total [Bank] Income:
>Control: =Sum([ASalesDepRS]+[AOIDepRS]+[AOSDepRS]+[ACDDepRS])
>Running Sum: Over All
>
>When I run the report, I am prompted for each of the *RS parameters and do
>not get a Total Over All for each bank. Please help me get it correct.


If ASalesDepRS, AOIDepRS, etc. are text boxes in the report,
it can;t work because the aggregate functions *Count, Sum,
etc) only operate on record source fields.

I think the bank total should probably be:
=Sum(SalesDep) + Sum(CashDep) + Sum(OtherIncDep) +
Sum(OtherSalesDep)

And the same expression in the report footer for a grand
total over all banks.

--
Marsh
MVP [MS Access]
From: ghetto_banjo on 13 May 2010 14:49
I don't think you need to use Running Sums here...

Since you are already grouping, using:

=Sum([SalesDep])
Running Sum: No

that should work in the Bank Footer I believe.


Then do the same thing in the Report Footer to get your overall total.
 | 
Pages: 1
Prev: Data changes when exporting a report to Excel
Next: Changes to "Issues" Template