Sum Function not working in subform HELP!

[Krispy1001]

Hi All! Please Help!!!

I am working on a subform and I am not able to get the sum function to work. I am using the following calculation: =sum([lineTotal]) I have place an unbound text box in the footer of my subform with that formula and it returns a "0.00" answer. I do not know why! The formula for "lineTotal" in the main body of my subform works correctly. The following formula is used for "lineTotal": =[prodWidth]*[prodHeight]/144 *[unitCost]*[prodQty] The formula is used to calculate square footage * unit cost * product qty. I have tried a lot of different ways to get the formula to work and I am out of ideas now.

Please Help!!!

Thank you, Kris

 

[neileg]

Try calculating LineToal in the underlying query, not the form.

 

[Krispy1001]

Thank you Neil I will try that.

Kris