Hi everybody
i have a store database
1- i have open stock query that contains a list of item Codes,item description,quantity and price and this list is limited
for example : open stock query for February (current month) has a 100 item code with previous details and that mean we begin February with 100 item
2- i have in query and this query contains all purchased items for current month. this query contains the same details of open stock query
3- i have sales query that contains all sold items for current month (February).
4- i have Stock Query to display the stock for current month and this stock list will used as an open stock list for march
and i calculate the stock by : Stock = (open stock + in ) - sales
i joined all queries using codes and date
my problem is when i sort my stock query fields as the follow :
date , code , des , OpenStock , In , sales , Stock
i joined code fields depend on open stock ItemCode
my problem is if i add a new itemcode in InQuery this itemcode does not display in the stock query because that new code doesn't exist from the beginning in the open stock query (100 + 1) . how can i add the new item code in InQuery and display in Stock Query
please help