calculations

[dave1234]

I have two tables..stock added and stock sold so when a particular stock item is invoiced out it takes it of the stock on hand but when I go to edit the stock item as to add another delivery of that item i.e say another 20 drums all the calculations in the stock added etc double up throwing the whole thing out....any ideas any would be appreciated.

stockleft: Sum(stockadded!Qtyadded-stocksold!Qty)

Thanks.

 

[Uncle Gizmo]

If you down load the pdf "20. Shipments" on this page,

It might help, I didn't read it!!!

 

[WayneRyan]

dave,

There was nothing in the database, so I added a couple of
records for washers and redid your query.

hth,
Wayne