"Calculating Text Boxes"

[MayoRR5]

Hi all,

I'm having a problem with a "calculating text box".

In the [Item_Total] box I have the control source "=[SumOfQuantity]*[Unit_Rate]" and [Unit_Rate] is a value that is calculated in the Query controlling the Report.

All works fine to this point. Then I have a group header and report footer and have a Sum control in a text box in both the header and the footer (not linked). The control for these is basically "=Sum([Item_Total])".

Basically when I try to preview the report, it is asking me to input a value for [Item_Total].

Thanks in advance for the help!!

MayoRR5

 

[neileg]

Try =Sum([SumOfQuantity]*[Unit_Rate]) instead of =Sum([Item_Total])

 

[MayoRR5]

Thanks Neil!!! That worked.

Any idea's why the SUM function just didn't work?

Thanks again for the help.

MayoRR5

 

[missinglinq]

Aggregate functions cannot be run against calculated fields. You have to run them against the same expression as is used for the calculated field!

 

[MayoRR5]

Ahh! I understand now.

Thanks missinglinq!!!