I have a db see attached file that i need to be able to see how many items are left unsold in a form that I use to sell items.
See form: sell madef rom sell Query
On theform see textbox Stock Live - it should show how many items are left. This is the problem I need to solve.
I have 2 tables:
warehouse - (ID, Items name, how many in stock, barcode)
sell -(ID, Items name, Quantity sold, Price sold)
There is One-To-Many relationship between table warehouse ID to table sell Items
There is also report: warehouse that lists items names, how many itms sold, items left in stock.
Query explanation:
Sell query - used to sell items form sell is made from it
sell query (integrated query2) - experimental query used to display all data
grupavimas - used to calculate how many items are sold
query 1 and query 2 - used to calculate the remaining items in stock.
If you have any suggestion how to achieve same thing easier please do no hesitate. Thanks
See form: sell madef rom sell Query
On theform see textbox Stock Live - it should show how many items are left. This is the problem I need to solve.
I have 2 tables:
warehouse - (ID, Items name, how many in stock, barcode)
sell -(ID, Items name, Quantity sold, Price sold)
There is One-To-Many relationship between table warehouse ID to table sell Items
There is also report: warehouse that lists items names, how many itms sold, items left in stock.
Query explanation:
Sell query - used to sell items form sell is made from it
sell query (integrated query2) - experimental query used to display all data
grupavimas - used to calculate how many items are sold
query 1 and query 2 - used to calculate the remaining items in stock.
If you have any suggestion how to achieve same thing easier please do no hesitate. Thanks
