SUM of Total of all groups (Grand Total)

[Corey]

I have a Report that lists, among other items, items with various numerical values(Stock Amount), under several Group Headers.

I want ot place in the Page Footer between the Date and Page # of #, a GRAND TOTAL or SUM of all the values on that Report.
I add a text box to the footer, and then go to the expression builder and proceed to put in : 'Sum([Stock Amount])'.

The report runs over into a 2nd page and I get nothing but an ERROR on the 2nd page footer.



What am I doing wrong ?
Any idea's???

Corey....

 

[Tom Lake]

I have a Report that lists, among other items, items with various numerical
values(Stock Amount), under several Group Headers.

I want ot place in the Page Footer between the Date and Page # of #, a GRAND
TOTAL or SUM of all the values on that Report.
I add a text box to the footer, and then go to the expression builder and
proceed to put in : 'Sum([Stock Amount])'.

The report runs over into a 2nd page and I get nothing but an ERROR on the
2nd page footer.



What am I doing wrong ?
Any idea's???


The grand total has to go in the REPORT footer, not a page footer.
It's only calculated at the end of the report.

Tom Lake

 

[Corey]

Hi,
I moved the field to the Report Footer, and now i get a '0'.

????

 

[Tom Lake]

Hi,
I moved the field to the Report Footer, and now i get a '0'.

????

You have the record source for the text field as:

=Sum([Stock Amount])

and it comes up 0?

Tom Lake