Add to exsiting value on update

[Mangler]

I need a quick suggestion on the best way to accomplish the below:

A user can update a record in the db on the front end so....

if this is the first entry they input the value and submit it....

if the exsisting value needs to be updated because more came in, I want
the update to add to the exsisting value automatically on the front end
when the form is submitted ( dont trust the users math skills )

any help/suggestions are appreciated.....

 

[Mike Brind]

I need a quick suggestion on the best way to accomplish the below:

A user can update a record in the db on the front end so....

if this is the first entry they input the value and submit it....

if the exsisting value needs to be updated because more came in, I want
the update to add to the exsisting value automatically on the front end
when the form is submitted ( dont trust the users math skills )

any help/suggestions are appreciated.....

Update Table Set field1 = (field1 + increment)