Summing an expression in a text feild (1 Viewer)

[Johnrg]

Guys,
I have the following expression in an unbound text box in the detail section of a report. I have checked it is working fine, which it is, and have made it invisible.

=NZ([300]*0.3)+NZ([400]*0.4)+NZ([600]*0.6)+NZ([900]*0.9)+NZ([1090]*1.09)+NZ([1200]*1.2)+NZ([1500]*1.5)+NZ([1800]*1.8)+NZ([2100]*2.1)+NZ([2400]*2.4)+NZ([2700]*2.7)+NZ([3000]*3)+NZ([3300]*3.3)+NZ([3600]*3.6)+NZ([3900]*3.9)+NZ([4200]*4.2)+NZ([4500]*4.5)+NZ([4800]*4.8)+NZ([5100]*5.1)+NZ([5200]*5.2)+NZ([5400]*5.4)+NZ([5700]*5.7)+NZ([6000]*6)+NZ([6600]*6.6)+NZ([7200]*7.2)

I want to SUM the number the this expression generates for each record at the end of my report in the report footer.

I tried, =sum(textboxname) but I did not work, I think I read somewhere you can't sum expressions in text boxes like this.

Can anyone let me know what I need to do in the report footer to get this sum to work?

JohnG

 

[pbaldy]

You read correctly; you can't sum a control. Your two basic options are:

=Sum(RepeatYourCalculationHere)

and to create a duplicate calculated textbox in the detail section with its running sum property set appropriately, then refer to that textbox in the footer:

=TextboxName