Sum by Column in a query connected in a subform?

L

ldiaz

I have a query named:qry_WOProduced that is connected in a subform for data
entry.
I would like to show in [RemainingQty] field the valance of a WO, for
example if a WO is for 15 Units, and it was captured two times, first time by
1unit and then for 10units, the valance should be: 3

I put a code like like... RemainingQty: [WOQty]-sum([Produced_Qty]) but it
does not work.

Work Order - WOQty -Produced_Qty -RemainingQty
1311443 - 15 - 1 - 3
1311443 - 15 - 10 - 3


Could you please help on this...?
Thanks in advanced.
 
Top