If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Calculating Sum of values

if i have a field called LinePrice in my "OrderDetails Subform1" and LinePrice is calculate by "=[unitprice]*[quantity]" then is it ok to use for a subtotal field located in the footer of the subform a field called OrderSubtotal calculated by =Sum([LinePrice])??

In the main form i want my subtotal field to be =[OrderDetails Subform1].Form!OrderSubtotal but it always displays £0.00 no matter the value of the order.