Report sum problem

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

Guest

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?
 
Gus said:
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?
Click to expand...

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.
 
Thanks!
--
thank You


Rick Brandt said:
Gus said:
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?
Click to expand...

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.
Click to expand...
 
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?
Click to expand...

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