INCREASING FIELD VALUE WITH A FIXED NUMBER

[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

 

[Duane Hookom]

Suggestion #1: stop shouting. Turn off the caps lock key.
Suggestion #2: try something like:
UPDATE tblA
SET FieldA = CStr(Val(FieldA) + 25));