Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Form/Subform Totals

Status
Not open for further replies.

FoxGolfer

Programmer
Jul 30, 2002
100
0
0
US
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
 
Hi!
maybe
Code:
=Sum[ExtendedPrice]?

greets,
Marko 9A6NCM

 
That was the first thing I tried; with no luck. But I was contacted by someone else who had a solution. Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top