Stock Control Problems!!!!!

[cath240]

hello looking for some help on mainting stock levels!!

- allow for quantity on hand
- amount on order
- amount sold

there is a stock table set up with following fields ;

StocKCODE
stockdescription
stockprice
stockquantity
stock items in delivery


we want to add the new number of stock items that came on delivery to the current stock quantity. We then want this total figure to appear in stockquantity.

we tried the following calculation with no joy!!!
[stockquantity]=[stockquantity]+[stockitemsindelivery].

Tried for many long hours,Please help!!!

Thank you in advance

 

[ggreg]

are you trying an update query... below I have an update query that is what I think your trying to do is update items on hand when they are receive?

UPDATE tblProducts INNER JOIN tblReceive ON tblProducts.ProductID = tblReceive.ProductID SET tblProducts.Unitsonhand = [Unitsonhand]+[ReceiveUnits]
WHERE (((tblReceive.ReceiveDate)=[Enter Receive Date]));

the only thing that i have is a criteria base a receive date that is
with or in the same table as ReceiveUnits


With the way your doing it, you just need to do something like ...UPDATE tableofstockquantity

SET tableofstockquantity.stockquantity =[stockquantity]+[stockitemsindelivery]

if you can take out my where statement and then put in your table and field names