return "text" when a table field contains 1

[rafnews]

Hello,



it's been a long time since i did some SQL queries on MS Access, but i forgot how to do to return a text for each row (as field value) when a table field contains "1" as value ?
for example i have a table named "products" with a field/column called "promotion". Sometime a product is promotional, so in this case, the "promo" column holds "1" as value.

during a select on products table, how can i do to return "in promotion" (e.g.) if the column "promo" holds "1" for a product ?

thx.

[June7]

IIf() expression in query or textbox:

IIf([promo]=1, "in promotion", "something else")