jjc9809
asked on
Access 2007 Question on Update Queries
Hi Everyone,
Please see my new database where I have made some changes .
Please analyze the Product Table. The IntitalQuantity field needs to update each time an item is sold. I will have a Complete Command Button above on the Main Form with the subform on top. When the user enters a sale and selects the Complete Button, I want an update query to run updating the InitialQuantity of each Code.
For Example: User enters a Qty 10 Units. The Initial Quatity in the Product Table is 1,000 Units. When the sale of 10 units is entered and the Complete button is selected, I want the InitialQuantity field to Update in the product Table to 990. The number 990 will be the new QTYAvailable for a product when a new order is made for the code.
i hope this makes sense.
Any help is very much appreciated.
jjc9809
TradeShowEE1.accdb
Please see my new database where I have made some changes .
Please analyze the Product Table. The IntitalQuantity field needs to update each time an item is sold. I will have a Complete Command Button above on the Main Form with the subform on top. When the user enters a sale and selects the Complete Button, I want an update query to run updating the InitialQuantity of each Code.
For Example: User enters a Qty 10 Units. The Initial Quatity in the Product Table is 1,000 Units. When the sale of 10 units is entered and the Complete button is selected, I want the InitialQuantity field to Update in the product Table to 990. The number 990 will be the new QTYAvailable for a product when a new order is made for the code.
i hope this makes sense.
Any help is very much appreciated.
jjc9809
TradeShowEE1.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
etech0
Glad to be of help. Good luck!