Newbie: SUM fails in report

[AlexT]

Folks

I'm having what is probably a totally newbie question with reports...

I have a rather simple report with Page Headers / Footers and Report
Header / Footers. My data source contains a numeric field, objPrice,
which I'd like to sum in those two sections.

I have added a calculated text box reading as =sum([objPrice]).

Well... this works fine in the *Report* footer but not in the *Page*
Footer (returns #error).

It must be a pretty basic (standard ?) mistake but I must admit that I
am at loss to explain it...

Any help welcome !

Regards

--alexT

 

[Guest]

Is there a good reason you need totals in page footers? This isn't normally
an easy task for a multiple page report. Group and Report totals are easy as
you have found.

There is an article you might find helpful at
http://office.microsoft.com/en-us/assistance/HA011224441033.aspx.

 

[fredg]

Folks

I'm having what is probably a totally newbie question with reports...

I have a rather simple report with Page Headers / Footers and Report
Header / Footers. My data source contains a numeric field, objPrice,
which I'd like to sum in those two sections.

I have added a calculated text box reading as =sum([objPrice]).

Well... this works fine in the *Report* footer but not in the *Page*
Footer (returns #error).

It must be a pretty basic (standard ?) mistake but I must admit that I
am at loss to explain it...

Any help welcome !

Regards

--alexT

See if this helps.
Microsoft Knowledge Base article
132017 "How to sum a column of numbers in a report by page"

 

[AlexT]

Duane, Fred,

Thanks for the pointers... most usefull !

--alexT