ACCESS Databse design

I have a warehouse inventory datbase and need somebody to do FIFO Inventory Calculation Formula on this datbase . I so I can show the result on my ASP website for my client . NO form design . The data Result should be either on queries or another tables . Here is more explanation : I have a inventory database which Containes 4 tables with ItemNo or I PrdtID as a related field between these 4 tables 1- Inbound 1a -Inbound Itemized Inbound table has Container number and Date it received Inbound Itemized table has the ItemNo Field and the quantity received , This itemNo. can be few different Items that received to our warehouse in one date and then there is the outbound 2- OutBound which has the order number and ship date 2a-OutboundItmized which has the ItemNo and QTY and dates that shipped .. the shipment of the item nu. can be in different data until the QTY of that Item number from that container is reachd ZERO balance which in my website will be disapear as been shiped and is out of the picture I want to make a query or procedure that show me the balance of that Item number in same query or differeny query and carry in forward for next order for that ItemNO . I hope I could get my point across Sample databses is attached . This is just a sample I will send the actual database later