How to change data in a table .

  • Thread starter Thread starter Martin Coole
  • Start date Start date
M

Martin Coole

I want to be able to keep a running total on how much
stock I have at any one time.When an order is placed I
need the quantity in products table to have the quantity
in the orders table deducted from it.
 
So run an update query to decrement the qtyonhand field for that particular
item when an order is placed, most likely in the After Update event

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/Newsgroups
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Passing the value to a table 1
Database design 0
Add/Subtract columns from tab to tab in same file 3
Products stocks level 1
Product table 1
Inventory transaction table - set up 5
Round Down by a specific number 0
How to make staff sales report and stock report 1

Back
Top