Change data name

[Alex Martinez]

Hello - Sorry for the double posting

I am using Access 2002 and I need some help on my query. I have a field
name "claim examiners", which I use the first name initial and the last name
initial of the examiners name. For example Janet Jordan the field will be
populated as JJ, Alan Mart will be AM. Now here is my problem I have three
examiners that I would like to change their initial. For example the
initial "BJ", "DC", and "KC" I want to change it to "OT" while the other
initials will not change. How do I do this. Your help will be appreciated.
Thank you in advance

 

[John Vinson]

Hello - Sorry for the double posting

I am using Access 2002 and I need some help on my query. I have a field
name "claim examiners", which I use the first name initial and the last name
initial of the examiners name. For example Janet Jordan the field will be
populated as JJ, Alan Mart will be AM. Now here is my problem I have three
examiners that I would like to change their initial. For example the
initial "BJ", "DC", and "KC" I want to change it to "OT" while the other
initials will not change. How do I do this. Your help will be appreciated.
Thank you in advance

You say you want to change "it" to "OT". I have no clue from your
sentence what is the "it" that you want to change!

An Update query with appropriate criteria is likely to be the
solution, but I don't know what those criteria might be (since 'it'
implies a single value but you list three).

One concern: Suppose you have examiners Janet Jordan, Jim Jenkins, Joe
Jeffries, and Jamal Jihadi. Which one is JJ, and how can you tell?
Should this ambiguous, nonunique, field even EXIST?

John W. Vinson[MVP]