Question

[Theseeker72]

Access database with two tables , incoming material and outgoing (selling) materials as follows
For the incoming
ID item qunty
1 laptop 5
2 mass storage 3
For the outgoing
ID Good_buyed quant_ty
1 laptop 2
2 mass storage 1
A query to run any time inventory by subtracting the sold material from the ones on stocks is keeping repeating the subtraction from the original value (initial value) and not the remains for each sale record added and show it on query multiple times as recorded
The query is :
SELECT Goods_buyers.good_buyed, material_detail.Item, material_detail.qunty, Goods_buyers.quant_ty,
([qunty])-([quant_ty]) AS Expr1
FROM material_detail INNER JOIN Goods_buyers ON material_detail.Item = Goods_buyers.good_buyed;
Any clues

 

[Uncle Gizmo]

In case you haven't seen it yet, you might like to have a look at Allen Browne's inventory blog, it's very insightful..

http://allenbrowne.com/appinventory.html

Sent from my SM-G925F using Tapatalk