#Error message on Report Footer

[PTDAccess]

Hi,

I am struggling to get a Textbox to calculate a total for one of my reports.

Im currently using the following for the Control Source:
=Sum([Amount])

It just produces "#Error" where the total should be. I have checked the data to make sure it is all the correct format & when i use the above formula on a forms footer there is no problem & the total is displayed correclty.

This problem has bugged me for a while now, any help would be greatly appriciated.

PTDAccess

 

[KenHigg]

=Sum(nz([Amount]))

???

 

[PTDAccess]

Hi Ken,

Tried that, the same error message is produced.

Thanks anyway

=Sum(nz([Amount]))

???

 

[pbaldy]

2 thoughts. If Amount is a calculated textbox on the report, you can't sum it. If it's a field in the data, make sure you don't have a control of the same name, which can cause problems (and of course that's what the wizard does).

 

[PTDAccess]

2 thoughts. If Amount is a calculated textbox on the report, you can't sum it. If it's a field in the data, make sure you don't have a control of the same name, which can cause problems (and of course that's what the wizard does).

It is not a calculated field & there are no other controls with the same name on the Report or Table.

Thanks for your input

 

[pbaldy]

Are you sure you're in the report footer and not the page footer? It will error in the page footer. If so, can you post a sample db?

 

[PTDAccess]

Are you sure you're in the report footer and not the page footer? It will error in the page footer. If so, can you post a sample db?

I had tried in both the Report & Page Footer, with the same result in both. Just created a sample to upload an it worked ok, so went back to original and it seems to be working fine now!

Thanks for your help

 

[gemma-the-husky]

do you already have a textbox called amount on your report

this would cause a problem, if you tried to sum a field of the same name