INCREASING FIELD VALUE WITH A FIXED NUMBER

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'M TRYING TO INCREASE A FIELD VALUE BY A FIXED NUMBER (25)
THROUGH A UPDATE QUERY. THE FIELD I'M TRYING TO UPDATE
DATA TYPE IS TEXT,BUT I CANNOT CHANGE DATA TYPE. ANY IDEAS
 
Suggestion #1: stop shouting. Turn off the caps lock key.
Suggestion #2: try something like:
UPDATE tblA
SET FieldA = CStr(Val(FieldA) + 25));
 
Back
Top