Printing a page total sum(amt)

G

Graham

Hi,

Many thanks in advance.


I am trying to add up all totals on a page.

I am using =sum(Amount) and it comes up #error.
It is contained within page footer. (If I put it in
report footer it works so I know the syntax is correct)

Please help me.
 
F

fredg

Hi,

Many thanks in advance.

I am trying to add up all totals on a page.

I am using =sum(Amount) and it comes up #error.
It is contained within page footer. (If I put it in
report footer it works so I know the syntax is correct)

Please help me.
Click to expand...

The syntax may be correct, but the Page Footer does not support the
direct summing of Detail controls.

For how to do this read Microsoft KnowledgeBase article:
132017 "How to sum a column of numbers in a report by page."
 
F

Fons Ponsioen

I suspect tha the name of the textbox is the same as one
of the variables (for instance amount). rename the
textbox to something different (for instance Amount1) and
that should fix the problem.
Fons
 
Top