Summing in a Report

[pepegot]

Microsofts says:
"Calculating group or report totals
To calculate the sum of the quantities ordered for the entire report, you place a text box control in the report footer and set the ControlSource property of the text box to the following expression:"
=Sum([QuantityOrdered])

However, when I do this I get "#Error" instead. What is the code to circumvent this short coming?

 

[KenHigg]

What is the field name you are trying to sum?

 

[pepegot]

Mia Culpa! I place the control box in the wrong location (Page Footer instead of Report Footer.) When I put it in the Report Footer it works as it should. Thanks for quick reply.
But, can you tell me the difference between the Page Footer & the Report Footer? Is the Page Footer for every page and the Report Footer at the end of the Report? Is it possible to place it the Page Footer section?

 

[KenHigg]

Mia Culpa! I place the control box in the wrong location (Page Footer instead of Report Footer.) When I put it in the Report Footer it works as it should. Thanks for quick reply.
But, can you tell me the difference between the Page Footer & the Report Footer? Is the Page Footer for every page and the Report Footer at the end of the Report? Is it possible to place it the Page Footer section?

Hum... Don't know - Give it a try

(? Mia Culpa ? )

 

[Rich]

Article ID: Q132017

in the MS Knowledge Base