sum a tabular form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a labor form that sums fine. My parts form has qty price and extended
price. The exteded price is calculated (price * QtY) but with this
calculation performed, the total parts won't return any results in the form
footer. =Sum(ExtPrice)
Please help!
 
I have a labor form that sums fine. My
parts form has qty price and extended
price. The exteded price is calculated
(price * QtY) but with this calculation
performed, the total parts won't return
any results in the form footer.
=Sum(ExtPrice)
Click to expand...

The Sum function does not work on Calculated Controls. You should be able to
do either of the following:

(1) Perform the calculation in the Query that is used as Record Source of
the Form to create a Calculated Field (say ExtenPr) and Sum (ExtenPr), or

(2) Try Sum(price * QtY) in the Footer

Larry Linson
Microsoft Access MVP
 
Back
Top