How to SUM an Unbound textbox??

[cglisc]

Hello,

Is there a way to sum an **unbound** textbox on an access
report? For example, I have textbox text1 in the
detail area, with the control source being a calculated
value. If I have text2 in the report footer, with
control source =SUM(text1), this does not work.
Access brings up the "Enter parameter value for text1"
window.

Any ideas would be greatly appreciated.

Thanks,
Chris

 

[CosmoKramer]

You can't perform an aggregate function on an unbound control. You have to recalculate the value, then sum it. So, if the control source for the text box in the detail section was:

=[field1] + [field2]

then the control source for the report footer control would be something like this:

=Sum([field1] + [field2])

Let me know if this helps.....