Change Value Based off Value in Field

[jo15765]

I have a field in my database called importance...has 3 values, High Medium Low. I want to in my query assign to a different Field Technician based off of this value, so I want to in my query, if the value is High show Joe Jones, if it shows Medium show Richard Samps, if it shows Low show Mitchel Mixson.

How would this conditional be set-up in my access query?

[Robeen]

Create a field in your Query something like this:

Field_Tech: IIF([Importance] = "High", "Joe Jones", IIF([Importance] = "Medium", "Richard Samps", "Mitchel Mixson"))

Let us know if it works.

[jo15765]

Disregard my post, I got it working:

IIF([importance]="High", "Joe Jones", IIF([importance]="Medium", "Richard Samps", IIF([importance]="Low", "Mitchel Mixson")))

[jo15765]

Create a field in your Query something like this:

Field_Tech: IIF([Importance] = "High", "Joe Jones", IIF([Importance] = "Medium", "Richard Samps", "Mitchel Mixson"))

Let us know if it works.

Looks like we were posting at the same time. Thanks for the response!