Hi

I would like to ask on how to generate a report on the stock movement transaction record.

E.g I have 5 tables which:
Table 1 as “Opening” which has the field as [Date], [Ref No],[Qtyl

Table 2 indicate incoming to stock as “GRN” which has field [Date],[Ref No] ,[Qty]
Table 3 indicate incoming to stock as “RFP” which has field [Date],[Ref No] ,[Qty]

Table 3 indicate outgoing to stock as “Invoice” which has field of [Date],[Ref No],[Qty]
Table 4 indicate outgoing to stock as “ITP” which has field of [Date],[Ref No],[Qty]

Remarks :
GRN ; Goods Receive Note
RFP : Return from Production
ITP : Issue to Production

Objection :

How to generate a report / query on the [Stock Balance] by linking all the tables above when I input the between date [Start Date] & [End Date] dialog box.

Thank you.

jiajian