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

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

Guest

I need help with replacing a value with another. Ex. where ADJT = 1 or ADMN
= 2 in the same field.
 
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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS word Find and Replace using Regex - Help required 0
Checkbox Export value to field? 1
Replace Function 2
Change the color of each capital letter in a rich text memo field. 0
Totals 7
MS ACCESS 2013 Long Text filed filter by another tables Long text field 1
Updating Table with another tables values 6
Count the columns from one sheet and paste it in another sheet 0

Back
Top