Hello,
I have created an stock entry database, and faced the following problems, i will appreciate your help in it.
1. I have created an (Access 2010) query for StockIN (please see the attached file), the files shows how many items i have available in stock table.
2. I have Created an other query for StockOut (please see the attached file), this files shows how many items have been out to company officials.
3. I have Created a 3rd Query for Stock Balance (please see the attached file)
Problem:
i have input 3 items (as you can see in stock in), and dispatched 2 items, but my Query is showing the available balance of two 2 items, the 3rd item is not showing in the balance query.
i have attached the structure of my balance query as well..
what i believe is that my balance query is only showing me the items i have subtracted from incoming stock, the 3rd item is not appearing in the balance query because it did not issue to someone.
but it must come in the balance query so that one can know that we have 1 camera in stock.
i hope i could convey my question in an understandable way
thanks