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
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