Using Sum() in Report/Page Footer

[Stevehewitt]

Hello People,

I posted this problem a week or so ago, and the resolution worked fine - but this is slightly different.

I have a calculated total using

Sum()

on each record on my report. On the page footer I need to have a total of all these

Sum()

fields.

The field is called txtInvTotal
I'm using the following as the control source of the field that should display the page total:

=Sum([txtInvTotal])

It just keeps on returning a

#ERROR

message!

I must be doing something really obviously wrong, but I can't think what it could be for the life of me!!!

Thanks in advance,


Steve

 

[gnasher]

This link should help

http://www.mvps.org/access/reports/rpt0004.htm