i want to be able to have a column that tells me what i have in stock. when an item is sold i want to deduct 1 from that ItemID column. im using an update query and dont worry i plan on having a reverse query if the item is deleted from the order.
for example. the item id is 123 and it has been added to an order
i thought that the criteria would be 123
the expression would be SUM([StockQTY]-1) but it doesnt like that.
the only fields i need are the ItemID and the StockQTY
thanks for any help
for example. the item id is 123 and it has been added to an order
i thought that the criteria would be 123
the expression would be SUM([StockQTY]-1) but it doesnt like that.
the only fields i need are the ItemID and the StockQTY
thanks for any help