Is there a way to write an expression in the Text Object box. For example I created a Text Object and I wanted it to display Value = Sum(Field). i want it to calculate the Sum(Field) and it does not.
YOu have to write
"=" sign is imp in text object
thanks for your response. But is there a way i can get the word "Value" to show up as well? For example I want my output to have the word "Value" then display the Sum(field).
Do the following (it's valid for expression labels, button texts, object captions and so)
='Value: ' & Sum(Value)
Hope that helps.
Thanks a lot.
Retrieving data ...