select query return "text" instead of "boolean value" (1 Viewer)

[alain.roger]

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.

 

[plog]

Use the Iif (http://www.techonthenet.com/access/functions/advanced/iif.php).

PromotionType: Iif(criteria, Output If True, Output if False)