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!

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

UPDATE command

Status
Not open for further replies.

xzibited2

Programmer
Joined
Dec 11, 2009
Messages
9
Location
US
I want to update a record within a table, but want to take the current value of the record and add it to the amount the user puts in. See below:


y = number of parts used

<code>
UPDATE partstable
SET partx= (current value of partx) + y
</code>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top