Stock Transaction Report

[jiajian]

Hi

I would like to build a DB for my company stock transaction for managing the goods IN & OUT.

(1) I have a table for goods coming in call IN1 which have field [Date],[Item],[Ref No],[Qty]
(2) I have another type of goods coming in call IN2 which have the same field too.
(3) I have a table for goods going out from stock call OUT1 which have the same field name
(4) I have another types for goods out too call OUT2 which have the same field.
(5) I have a table for the opening stock call OPEN which have field [Date],[Item],[Qty]

Question

How call I have a stock report whch when I call out the item & the Date Start & Date End, I will have a report list out all the related transaction which have :
{Date},{Ref},{Qty In},{Qty Out},{Balance Qty}

Thank you

jiajian

 

[Nouba]

you can get some hints about that on Allen Browne's site: Inventory Control: Quantity on Hand

 

[Rich]

Date is a reserved word in Access, you should change the field name to something else to prevent problems in the future.