I have a subform that has a control "ExtendedPrice" with the ControlSource, =([ListPrice]*[Multiplier])*[Qty]. This correctly calculates the ExtendedPrice.
To create a SubTotal value, I have a control "QTotal" in the subform Footer with a ControlSource, = Sum(([ListPrice]*[Multiplier])*[Qty]). This displays #Error. ??
Thankx,
Tom
To create a SubTotal value, I have a control "QTotal" in the subform Footer with a ControlSource, = Sum(([ListPrice]*[Multiplier])*[Qty]). This displays #Error. ??
Thankx,
Tom