Stock Control in MSAccess

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