How to sum the textboxs in a report

[kai]

Hi, All
I use Access2002. I have a report, on each group I have a subtotal (not
directly from fields, get from on report calculation) with name txtSubTotal.
At report level, I want sum up "txtSubTotal", I use Sum([txtSubTotal]) but
Access pops up a input window asking for parameter for "txtSubTotal". Is it
possible to sum up textbox on a report? I tried everything, I still could
find the solution. I really appreciated any help.

Thanks

Kai

[Larry Linson]

With a little more information, perhaps someone could help.

No, you cannot use the Sum function to total a Calculated Control on a
Report, but you _may_ be able to use a Sum that does the calculation.

Larry Linson
Microsoft Access MVP
"kai" <ka******@earthlink.net> wrote in message
news:vH***************@newsread1.news.atl.earthlin k.net...

Hi, All
I use Access2002. I have a report, on each group I have a subtotal (not
directly from fields, get from on report calculation) with name txtSubTotal. At report level, I want sum up "txtSubTotal", I use Sum([txtSubTotal]) but
Access pops up a input window asking for parameter for "txtSubTotal". Is it possible to sum up textbox on a report? I tried everything, I still could
find the solution. I really appreciated any help.

Thanks

Kai