calculated control gives error

keyur

Registered User.
Local time
Today, 16:38
Joined
Jun 22, 2004
Messages
41
hi

maybe this is very simple but i just cant get it to work
on my report i want sum of a field. so i have a textbox with controlsource
"=Sum([Total on Hold])" which gives me an error.
if I do "=[Total on Hold]" it gives the value from the last record.

Could anyone help me figuring out what am i doing wrong here?

Thanks a lot.
 
Is [Total on Hold] a calculated field? you have tried it without the quotes haven't you?
 
I am using quotes for the message only and not in the control source
property. And [Total on Hold] is a field in the table.

Thanks again.
 
What is the name (property) of the text box you are using for this? If the name is "Total On Hold" that would be your problem.
 
Is the sum textbox in a footer?

???
ken
 
sorry guys could not come reply earlier.
sorry Rich I am confused in which textbox you are talking about
the name of the textbox which displays the:
- field is 'TotalonHold' (yes, no spaces)
- total is 'Tot'

Yes Ken, the textbox is in the footer.
 
Well, it's one of 2 things. Either your text box has the same name as a field in your table or you are trying to sum in the page footer. You can sum in the report footer but you will get #Error if you try to sum in the page footer. In order to display a sum in the page footer you need to do it in a roundabout way. You can't simply use Sum([SomeField]).
 
Last edited:

Users who are viewing this thread

Back
Top Bottom