Adding or Substractint to a current value

  • Thread starter Thread starter kikeman
  • Start date Start date
K

kikeman

Hi,

I have a table with a column "Hrs" that is a double type.

I would like to add or substract hours to the current value with a single
UPDATE command. i.e:

Orders Hrs
Q6E4D3 2.5

I would need to add 3.5 hrs:

Orders Hrs
Q6E4D3 6.0

What would be the SQL UPDATE command to do this?

Thanks,
kikeman.
 
UPDATE MyTable
SET Hrs = DateAdd("n", 210, [Hrs])

will add 210 minutes (3.5 hours)
 
Back
Top