Multiple IF statement

[Lynn73]

I have a field which shows numbers 1-8 or is null.
I want to group this to show if its 1,3,5,7 then it shows as "BOOK" else if its 2,4,6,8 then its "CHAIR" and if its null then show it as null
Can anyone help - I am using Access 2003

 

[Jon K]

IIf([FieldName] In (1,3,5,7), "Book", IIf([FieldName] In (2,4,6,8), "Chair", Null))

If it is a text field, you need to put the numbers in quotes i.e. ("1","3","5","7")
.

 

[Lynn73]

Works great
Thanks for your help