hannaford123
New member
- Local time
- Today, 06:46
- Joined
- May 7, 2013
- Messages
- 1
Hi - am very rusty user of Access 2010 so would appreciate siimplicity in replies please!
I have a Sales database with Products, Orders and OrderDetails tables amongst others and am required to update the QuantityinStock in the products table as well as identify low stock levels. I have successfully created a low stock level Query but am really struggling with updating the QuantityinStock field.
Reading the forums there are many suggestions as to the way to do this from an update query, to DSum, to not holding quantity in stock as a table value in the first place! I have tried an update query and DSum without success.
I have however successfully created a query that totals the quantity sold for each product ID which I could add to the Products table as a new field "ProductsSold" if I could just work out how to run it as an update query - it uses a SUM function and just presents me with a parameter query when I try and run it?
Any help would be much appreciated!
I have a Sales database with Products, Orders and OrderDetails tables amongst others and am required to update the QuantityinStock in the products table as well as identify low stock levels. I have successfully created a low stock level Query but am really struggling with updating the QuantityinStock field.
Reading the forums there are many suggestions as to the way to do this from an update query, to DSum, to not holding quantity in stock as a table value in the first place! I have tried an update query and DSum without success.
I have however successfully created a query that totals the quantity sold for each product ID which I could add to the Products table as a new field "ProductsSold" if I could just work out how to run it as an update query - it uses a SUM function and just presents me with a parameter query when I try and run it?
Any help would be much appreciated!
