Hello All,
First of all let me say Hi to all of you, this is my first post/request to solve the issue. I tried what i could but no luck so far.
I'm trying to retrieve information from 3 tables (Order, Receive and Issue) to one table as Inventory Table/Query. it looks like as follows
Order Table: OrderID
ProductID OrderDate OrderQTY 1 1 3/1/2012 30 2 1 4/1/2012 10 3 2 4/1/2012 20
Receive Tabe:
ReceiveID ProductID ReceiveDate ReceiveQTY 1 1 3/3/2012 30 2 1 4/3/2012 10 3 2 4/2/2012 15
Issue Table:
IssuedID ProductID
IssuedDate IssueQTY 1 1 3/5/2012 20 2 1 4/6/2012 10 3 2 4/5/2012 5
I'm looking for Inventory table/query which will give all of the data per date, which is like the following
Inventory:
Date ProductID OrderQTY ReceiveQTY IssueQTY 3/1/2012 1 30 3/3/2012 1 30 3/5/2012 1 20 4/1/2012 1 10 4/1/2012 2 20 4/2/2012 2 15 4/3/2012 1 10 4/5/2012 2 5 4/6/2012 1 10