IIf Statement in Calc Expression

[Tina Hudson]

I'm working on a calculated expression which contains
fields and strings. I want to know if there is an easier
way to do what I want to do.

This is what I want: "For the Creative Arts & Sciences
Magnet Schools (Bugg and Douglas)....."

Where: "Creative Arts & Sciences Magnet" is a field
[DisplayName], and (Bugg and Douglas) are the names of 2
schools. DisplayName is the name of a school model.

I would prefer having a query that tells me the names of
the schools for each school model and places all schools
for a particular model in parentheses after the model
name. But I can't seem to do that with a query.

What I thought might do it, but would be time consuming,
would be to include an IIF statement in the string
expression, such as:

="For the " & [DisplayName] & " " & IIf([Model]
=1,"(Root)", IIf [Model] = 2, "(Lincoln Heights)", IIf
[Model] = 3,"(Bugg and Douglas)" ....

And so forth, until all models have been assigned
schools. I don't even know if the IIF statement is
written correctly, so if not, please correct. However,
I'd love to know if there is a simpler way to accomplish
this.

Thanks so much for any help!

Tina Hudson

 

[Fons Ponsioen]

The following may be a possibility:
If the values are consecutive, low numeric values (ie
1,2,3,..) then consider using the Choose() function
=Choose([FieldValue],"Root", "Lincoln", "Bug")
etc
Hope this helps.
Fons