Stock Control Database Where Scans of Barcodes Are Counted When Scanned!

[Durks123]

Hi All,

I am in a bit of a pickle with my recent database that i am trying to make.

My brother runs a HGV breakers yard and we are trying to created a stock database where we print a label out for each product with a barcode on it.

What i would like to do in the database is to have a stock in and a stock out database which is added to each time a product is either removed from a vehicle and put on the shelf (Stock In) or sold (Stock Out) and then on a separate table or query to have a quantity of the items we have controlled by the amount of items i have scanned in and out (Say if in the scanned in was 10 items and scanned out was 2 the total would be 8)

Is this easily possible or not.

Any help is greatly appreciated



Cheers,
Joe

[June7]

It is not easy and not good design. Ideally, do not save aggregate data. The risk of saved data getting out of sync with raw data is high. Save transactions of product in and out and calculate the balance when needed. Review http://allenbrowne.com/AppInventory.html