Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

update stock quantity

Status
Not open for further replies.
airbase

airbase

Technical User
Jan 30, 2002
21
CN
Hi,
I have a database(Access 2000) about the Vehicle parts control. i have part control table & part sales table & parts used in servicing table.

The user need know how many quantity in stock everytime when he open the partcontrol form. How can i update the part quantity after being used or sold?

Any help will be appreciated.

 
Status
Not open for further replies.

Similar threads

supportsvc
  • Locked
  • Question
How to limit the number of records based on the quantity in a field? 1
Replies
8
Views
202
supportsvc
supportsvc
MattGreer
  • Locked
  • Question
Can't update a field from a query result due to 'Group By'
Replies
2
Views
87
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
Using Domain Aggregate expression in Update Query 2
Replies
12
Views
114
TheresAlwaysAWay
TheresAlwaysAWay
puforee
  • Locked
  • Question
Query update issue
Replies
5
Views
85
Andrzejek
Andrzejek
JoPaBC
  • Locked
  • Question
Update data directly in select query recordset 1
Replies
10
Views
139
JoPaBC
JoPaBC

Part and Inventory Search

Sponsor

Back
Top