Sum up a calculted field

[yduckfr]

I have in a query a calculated field named dblSubTotal with the calculation "intQuantity * fltCost", then I have a field on my subform with a locked field named txtSubTotal with the control source dblSubTotal, then I tried to create a field in the footer of the subform with the name txtTotalcost with the control source of "=sum ([dblsubtotal])" but it gives me #error

Any help would be greatly appreciated

 

[PHV]

And what about this ?
=Sum([intQuantity] * [fltCost])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[yduckfr]

well i tried that one too and it gave me the correct result first, but then i closed the form and when i reopened it it gave me again the same old result #error

 

[PHV]

And this ?
=Sum(Nz([intQuantity],0) * Nz([fltCost],0))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[yduckfr]

First of all THANKS for your help

by now i've tried already everything that u can think of but i still had that problem so finaly i figured that i'll try to recalculate that field in the current event of the main form and it works now

Thanks again