Sum Problem

[mithani]

Hi,

I have one form with subform. I want to have sum at main form. I am using below code, but showing Error.

Sum is based on weight(subform), cutting length(subform), Qty unit(subform) and Quantity(main form).

=Sum([tblEstimatingChild subform].Form!weight*([tblEstimatingChild subform].Form!CuttingLength/1000)*[tblEstimatingChild subform].Form!QtyUnit*[Quantity])

If i remove sum, than showing total weight of the last row.

Any Idea?

Thanks

Mithani

 

[mithani]

Mates

Any help?

Thanks

mithani

 

[mithani]

Thank you,

I solved this problem.

Mithani