Query for a Periodic Report in using MS Access 2010

See more:

MS-Access

I am developing an inventory system in vb6 with access 2010. We have a main Store where we receive Products from different Vendors and then distribute the products to our sub-stores located at different locations. I want to create a periodic activity report of every location like what was the opening-balance, how many New items were transferred or repeated , what was the quantity Returned and how may were sold. For which I have created two tables

Table Name : Store contain fields as under:
STORE
Field Name Type
ProductID Text
Onhand Number
LocationID text
ClosdingDate Date
ClosingQty Number

LOGDETAIL
Field Name Type
LogID Text
LogDate Date
ProductID Text
LocationID Text
Action Text
QtyIN Number
QtyTransfer Number
QtyRetrun Number
QtySale Number
Rate Number

What will be the query for following report format.
From Dt:01/09/2014 ToDt: 15/09/2014
LocID ProdID RATE OldBalance QtyTransfer QtyReturn QtySale ClosBlance
B AA1 1000 4 3 0 0 7
B AA2 2500 0 4 0 0 4
B BB1 3000 6 0 0 0 6
B BB2 1000 0 4 0 4 0
B BB3 1500 3 0 0 0 3
B CC1 3000 6 0 6 0 0
B CC3 1200 0 10 2 5 3
19 21 8 9 23