Re: SQL Query statement (Sum problem)

UPDATE MyTable
SET TotalQty = ( TotalQty + NewItems )
WHERE ProductIdentifierColumn = ProductIdentifier

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


<neo.monty@xxxxxxxxx> wrote in message
news:1166510381.021239.85510@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Actually I've an Items table which has a field(TotalQty), now i need a
sql query so that everytime new items arrive in my store, i can add
the number of quantity of item arrived to the existing quantity entry
in the databse. Hope u understand me.
Any help will be appriciated.
Thanx in advance.



.