changing data to a different name

[Alex Martinez]

Hi,

I am using Access 2002 and I have a field called "Dispute" it contains two
letters a reviewer first name initial and their first last name initital for
example DJ or ZH, etc. What I want to do is when a record contains the
initial "BJ" or "DC" or "KC" only then I want to change it to "OT". How
do I do this? I tired the below code but it doesn't show the other
reviewers - example "DJ" or "ZH" etc. Any tips will be appreciated. Thank
you in advance.

iif([Dispute]="BJ", "OT", iif([Dispute]="DC", "OT", iif([Dispute]="KC",
"OT", [Dispute])))

 

[Guest]

Set the control source property of the text box on your report to the line
below. Make sure the name of this text box is not called Dispute.

=iif([Dispute]="BJ" Or [Dispute]="DC" Or [Dispute]="KC","OT",[Dispute])