Hey there

to start of with my sql is pretty poor when attempting complicated queries
so i was wondering how to do the following

l_sqlStmt = "UPDATE stocktakeitem SET "
l_sqlStmt &= "qty = qty + " & p_sti.Qty & " "
l_sqlStmt &= "WHERE stiid = " & p_sti.StockTakeItemID

its the bold part im trying to work out i want to update the qty that exists by adding the old qty and new qty together.

im sure its a subquery thats involved here