SUM of Text Box Values

[iamedwardkim]

I have a text box in the Detail section of my report. I am trying to calculate the sum of all the values in this text box and place this total at the footer of my report. Is there a way I can do this? The value in the text box is determined by an IIf statement.

 

[PaulBricker]

If the textbox is calculated like this
IIf(Something = somevalue, 134, 0)
then in the footer you have to have
Sum(IIf(Something = somevalue,134,0)

that should do it.

Paul