Column Sum in Footer - help?

[Julie Smith]

Hi,
I have created a Tabular report that lists names and weights for different
people. I want to create a stand-alone field in the page footer that will
display the SUM of all the weights on the report. Can somebody please help
me? (I'm using Access 2000 btw)

I have tried creating a text box with the Control Source property set as
"=Sum(weight)". However, this just produces an error.

Thanks in advance.

 

[Marshall Barton]

Hi,
I have created a Tabular report that lists names and weights for different
people. I want to create a stand-alone field in the page footer that will
display the SUM of all the weights on the report. Can somebody please help
me? (I'm using Access 2000 btw)

I have tried creating a text box with the Control Source property set as
"=Sum(weight)". However, this just produces an error.

As long as Weight is a field in the report's record source
table/query, your Sum expression is fine.

The problem is that you can not use aggregate functions in a
page header/footer. Move the text box to the report footer.