How do I add amounts from subforms for a totals footer?

  • Thread starter Thread starter M Skabialka
  • Start date Start date
M

M Skabialka

I have a report with a subreport, which has a list of costs.
The main report has a $ amount funded, it then gets the sum of costs from
the invisible footer on the subform and lists that on the report as
expended. Then it subtracts and shows a balance.
I would like at the bottom of the main report to show the Sum Total of the
all funded amounts, the Sum Total of the expended and Sum Total of the
balance.
=SUM([TotalFunded) works for the funded - this is the actual field name.
But =SUM([TotalExpended)] doesn't work, which is what I called the main
report field which gets data from the subform for that piece of funding.

How do I refer to the total of all of the Amounts Expended extracted from
the subform for each Funded amount so I can use that on the main form
summary?
Mich
 
M said:
I have a report with a subreport, which has a list of costs.
The main report has a $ amount funded, it then gets the sum of costs from
the invisible footer on the subform and lists that on the report as
expended. Then it subtracts and shows a balance.
I would like at the bottom of the main report to show the Sum Total of the
all funded amounts, the Sum Total of the expended and Sum Total of the
balance.
=SUM([TotalFunded) works for the funded - this is the actual field name.
But =SUM([TotalExpended)] doesn't work, which is what I called the main
report field which gets data from the subform for that piece of funding.

How do I refer to the total of all of the Amounts Expended extracted from
the subform for each Funded amount so I can use that on the main form
summary?
Click to expand...


Sum only operates on record source fields, it is unaware of
controls in a form or report.

Add another text box that gets the total ecpended from the
subreport and set its RunningSum property to Over All. Your
report footer text box can then refer to the running sum
text box to get the grand total expended.
 
This worked - thanks. I was using running sum in all the wrong places.
Mich

Marshall Barton said:
M said:
I have a report with a subreport, which has a list of costs.
The main report has a $ amount funded, it then gets the sum of costs from
the invisible footer on the subform and lists that on the report as
expended. Then it subtracts and shows a balance.
I would like at the bottom of the main report to show the Sum Total of the
all funded amounts, the Sum Total of the expended and Sum Total of the
balance.
=SUM([TotalFunded) works for the funded - this is the actual field name.
But =SUM([TotalExpended)] doesn't work, which is what I called the main
report field which gets data from the subform for that piece of funding.

How do I refer to the total of all of the Amounts Expended extracted from
the subform for each Funded amount so I can use that on the main form
summary?
Click to expand...


Sum only operates on record source fields, it is unaware of
controls in a form or report.

Add another text box that gets the total ecpended from the
subreport and set its RunningSum property to Over All. Your
report footer text box can then refer to the running sum
text box to get the grand total expended.
Click to expand...
 
Back
Top