Report sum problem

[Gus Chuch]

I got to be missing something simple.
To get a sum ( not a running sum) on a report you place the text box
=Sum([SumOfIncome]) in the Page Footer right? I keep getting a #error on the
report.
What am I doing wrong?

 

[Rick Brandt]

I got to be missing something simple.
To get a sum ( not a running sum) on a report you place the text box
=Sum([SumOfIncome]) in the Page Footer right? I keep getting a #error
on the report.
What am I doing wrong?

Report and Group Header/Footers work for that. Page Header/Footers do not.
You have to do some additional work to get totals at the page level.

Microsoft has a Knowledge Base article on their web site that explains how
to do this if you can find it.

 

[Gus Chuch]

Thanks!
--
thank You

I got to be missing something simple.
To get a sum ( not a running sum) on a report you place the text box
=Sum([SumOfIncome]) in the Page Footer right? I keep getting a #error
on the report.
What am I doing wrong?

Report and Group Header/Footers work for that. Page Header/Footers do not.
You have to do some additional work to get totals at the page level.

Microsoft has a Knowledge Base article on their web site that explains how
to do this if you can find it.

 

[fredg]

I got to be missing something simple.
To get a sum ( not a running sum) on a report you place the text box
=Sum([SumOfIncome]) in the Page Footer right? I keep getting a #error on the
report.
What am I doing wrong?

See Microsoft KnowledgeBase article:
132017 "How to sum a column of numbers in a report by page"