If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Total not correct in Footer
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 a 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. |
#2
|
|||
|
|||
Total not correct in Footer
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 a 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] |
#3
|
|||
|
|||
Total not correct in Footer
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. |
Thread Tools | |
Display Modes | |
|
|