Stuck on simple calucation in report footer

[Mansoor Ahmad]

I am trying this simple calculation for last 2 hours but still not successful.

A group footer in a report has a text box Text100 with control source e.g

=[Text50]+[Text23]+[Text69]

Now on the same Report footer I want to calculate the sum of all the values for all groups

I used a text box with control source

=Sum([Text100])

But it does not recognize Text100

Can somebody please let me know how to calculate overall sum in report footer?

thanks

 

[Rich]

=Sum([Text1]+[Text2]+ [Text3])

 

[Mansoor Ahmad]

Thank you for your reply.

I had already this but somebody has suggested me followings

sum([Text50])+sum([Text23])+sum([Text69])

which I hope would solve my problem

Thanks again