How to store the total value of a colum from a query in a field in another table?

[Lparra]

I have a Parts Table with parts numbers and additional information also I have a subform linked to a Purchase orders table.
On the Purchase orders table I have a column Quantity which is the quantity order on that specific PO.
Now what I am trying to do is calculate the Below stock Level Qty field which is in the Parts Table
by the following formula: Below stock Level Qty = Recommended stock level - (Quantity on Hand + the total quantity of pcs ordered in all the PO's from Purchase Orders table which in this case will be "3")


how do I capture the value of the total from column Quantity on the Purchase Orders table to use it in the formula?

I appreciate any help provided!

[ranman256]

in the subform footer,
ad a text box , set the source = Sum(Qty)

[Lparra]

Hello,

Thanks for your prompt response. So I cretaed a text box in the subform footer and named it Total Ordered how can I capture this value of this text box and store it in a table?

Thanks,

[Lparra]

My low stock level is a calculated field which is = Recomended Stock Level - Quantity on Hand but I need to take in consideration the quantities in PO's that have been ordered already there fore I need to include the Total Quantity Ordered in the formula but that value is a Sum from a column from a different table.