By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,905 Members | 2,075 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,905 IT Pros & Developers. It's quick & easy.

Update Inventory

P: n/a
Products appear on multiple orders in a batch of orders. I created a totals
query with the fields, ProductID and SumOfQuantity. I have a TblProduct table of
products with the fields ProductID, Inventory, and other fields not relevant
here. My intent was to join the query and the table on the ProductID fields in
an update query to update Inventory by [Inventory] - [SumOfQuantity]. The update
query turned out to be not updateable.

I need ideas on another approach to update inventory from sales on multiple
orders.

Thanks!

Melissa
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
For an introductory discussion of this big question, see:
Inventory Control - Quantity On Hand
at:
http://allenbrowne.com/AppInventory.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Melissa" <mw*****@earthlink.net> wrote in message
news:QA*****************@newsread1.news.atl.earthl ink.net...
Products appear on multiple orders in a batch of orders. I created a totals query with the fields, ProductID and SumOfQuantity. I have a TblProduct table of products with the fields ProductID, Inventory, and other fields not relevant here. My intent was to join the query and the table on the ProductID fields in an update query to update Inventory by [Inventory] - [SumOfQuantity]. The update query turned out to be not updateable.

I need ideas on another approach to update inventory from sales on multiple orders.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.