querying and converting text to numbers

[hollyh]

I inherited a database, so bare with me. The person who had this database before me

-created a main table with a column SMOKING
-linked to a query of another table
called YNDK with ID autonumber, then yes..no..don't know

I would like run a query to convert these values to either 2 for yes or 1 for no or null/blank

IIf statements do not work. Any advice? Thanks.

[rpeare]

iif([SMOKING] = "No", 1, iif([SMOKING] = "Yes", 2, null))

[hollyh]

i must be losing my mind

thank you