Adding labels in new column

[Hello World]

Hi all,



How do I do an if statement in Access so that if I have a column with numbers 1-7 in I can add a column next to it which shows the 1’s as “Daniel”, 2’s as “Bob”, 3’s as “Steve”, etc

Thanks

[alansidman]

Instead of an iif statement, I would create a new table with two fields.

tblName
NameID (PK)--Autonumber
NameDesc --text

Join this table with your existing table on the NameID and your field having the numbers.

Make the NameDesc field part of your query. The names corresponding to the numbers will appear in this column in the query