twen wrote:

Prefix: Switch(IsNull([MrMrs]) Or [MrMrs]="",[First] & " " &
[Last],[MrMrs]=1,"Mr.",[MrMrs]=2,"Mrs.",
[MrMrs]=3,"Ms.",[MrMrs]=4,"Miss",[MrMrs]=5,"Mr. & Mrs.",[First] & " " &
[Last])

Will that work in a query if I have 1,2,3,4,5 stored as values for the
Prefix field and I want to show the values Mr. = 1, Mrs. = 2, Ms. = 3, Miss =
4, Mr. & Mrs. = 5, Else = First & " " & Last.
Should I be using a switch or an IIF function in the query. The only reason
I have this is when the user exports it to Excel I do not want numbers just
showing up I want values. Any help anyone, currently it is giving me an error
and I do not know the reason why. The value that comes up in the query is
#ERROR.


You have mixed a couple of [First] & " " & [Last] in there.

The MeMrs field should not be a Text field, which will make
the check for "" an error.

I think(?) it would be easier to use the Choose function:

Prefix: Choose(Nz(MrMrs, 6), "Mr.", "Mrs.", "Ms", "Miss",
"Mr. & Mrs.", "") & First & " " & Last

--
Marsh
MVP [MS Access]