Question Locked
Stock Control in MSAccess
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Using the northwind sample database as an example, how do you update the unitsinstock field in the products table based on units sold per order. An update query doesn't do it properly. Also if new stock is received, how do you update the unitsinstock field?
Thanks
Jim