I am familiar with IIf statements, but does anyone know how to nest these
statement, or a better solution e.g
=IIf([Number]=1,"one") Or
=IIf([Number]=]=2,"two") Or
=IIf([Number]=]=3,"three")
The Choose() function is one option: it takes an arbitrary number of
arguments; evaluates the first as an integer; and then uses that integer as an
index to the remaining arguments. In your case
NumberName: Choose([Number], "one", "two", "three", "four", <etc etc>)
Alternatively you could set up a small translation table with two fields,
Number and NumberName, and just join it to your query. This would be the
better alternative if you are going much beyond ten.
John W. Vinson [MVP]