Column Sum in Footer - help?

  • Thread starter Thread starter Julie Smith
  • Start date Start date
J

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


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.
 
Back
Top