Problems with a SUM Function

[sondriven]

I have a report based on a query that calculates a figure for me. I want to take that figure and have a total at the bottom of the report.

I put a field at the footer of the report and entered this in the control:

=Sum([Cost])

Im getting the pesky #error on the report. Seems like a simple fix....im hoping.

Thanks for any help.

john

 

[sondriven]

I just tried something. I put the text box with the calculation in the body of the report and it works perfectly, but then as you know, it shows up as many times there are entries. So thats the reason I want it in the footer, but when its there I get the #error. Confused...

john

 

[sondriven]

Voila!! Unconfused....I was putting the calculated field in the page footer, not the report footer. Works like a charm!

Later

 

[Cosmos75]

Veni, Vidi, Vici??

He came, He asked, He answered himself..


Well done!