Help with replacing a value with another ex: replace ADJT with 1,.

J

jrhp62296

I need help with replacing a value with another. Ex. where ADJT = 1 or ADMN
= 2 in the same field.
 
J

John Vinson

I need help with replacing a value with another. Ex. where ADJT = 1 or ADMN
= 2 in the same field.
Click to expand...

An Update query will do this, but I don't understand the situation
clearly enough to say. Do you mean that you want to replace all
instances of the text string ADJT with the text string "1", and all
instances of ADMN with "2"? How many other codes need to be replaced?
Do you want to permanently discard the four-letter codes, or replace
the Text field with a Number field?

John W. Vinson[MVP]
 
Top