TOTALS Subform

[matrixindicator]

I thinks its a dummy question, searching previous I could not find the right answer.

I have a subform, listing a few lines (orders) of record, for each order there are fields [PRICE] [PRICEVAT] [PRICETOT]. I need to get the subtotal in the footer on this subform.

=Sum([PRICE]*[NUMBER])

I get the #error message when trying to get the sum of PRICETOT [PRICE+VAT] * ORDERED NUMBERS

 

[matrixindicator]

=[Order Details Subform].Form![Order Subtotal]

I found this, but this is placed on the main form referencing to the subform and not in the footer of the subform.

 

[PHV]

You wanted this ?
=Sum(([PRICE]+[PRICEVAT])*[NUMBER])

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[matrixindicator]

it could be that, but refering to the name of the textbox where the a previous calcualation is made, is not working fine. I solved it by simple write out the complete calculation, not refering to a unbound textbox.

=Round(nz(Sum(([SELLPRICE]+([SELLPRICE]*[TARIF]/100)))*[ODNUMBER]);2)