Sum text box in Footer??? Please help...

[bsnapool]

Hi All,

In need a quick fix, need to get these reports in ASAP.

I have a text box which looks at the fields in The "Detail" part of the report. which looks like this:

IIf(Len([SumOfCost] & "")=0,[SumOfSumOfActivity Cost],[SumOfSumOfactivity cost]-[SumOfCost])

But in the group I would liek to sum the Text box.

I have put a simple sum =Sum([Text173]) but it does nt sum the the rows of data in the Detail section. Any ideas?

Appreciate any help... Clock is ticking too...

Thanks

 

[pbaldy]

You can't sum a calculated control. You can repeat the calculation within the Sum() function in the report footer.