Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to sum a value in my page footer, I have in
the detail section the data I want to sum. In the detail
I have (Name.TotalDailyExpense) and the control source is =
[AmountBilledforCaseManager]+[AmountBilledforJobCoach]+
[AmountBilledforCrew]. In the detail this adds up
correct, now if I go to the Page footer and try =Sum
(TotalDailyExpense) I get an #Error???? But if I copy the
TotalDailyExpense and place it in the page footer, it
returns the first of the details in the page footer. Any
idea, is this common or is there something I am just over
looking???

-Steven M. Britton
 
I am trying to sum a value in my page footer, I have in
the detail section the data I want to sum. In the detail
I have (Name.TotalDailyExpense) and the control source is =
[AmountBilledforCaseManager]+[AmountBilledforJobCoach]+
[AmountBilledforCrew]. In the detail this adds up
correct, now if I go to the Page footer and try =Sum
(TotalDailyExpense) I get an #Error???? But if I copy the
TotalDailyExpense and place it in the page footer, it
returns the first of the details in the page footer. Any
idea, is this common or is there something I am just over
looking???
Click to expand...

What you're seeing is normal. Page header/footer sections
do not accomodate the aggregate functions since a page is
not a data identifiable group to aggregate on. The Sum
function works great in the report and group
headers/footers.

In addition, the aggregate functions only understand fields
in the report's record source table/query, it can not use a
calculated value in a control. So, if you were using Sum in
a group footer section, then you would have to write it this
way:

=Sum([AmountBilledforCaseManager]+[AmountBilledforJobCoach]+[AmountBilledforCrew])
 
Back
Top