Query help

[Mom2B]

I have a query where I want to retrieve
"YES" if tableName.repla cement = 1 and
"NO" if tableName.repla cement = 0 and
"DONT KNOW" if tableName.repla cement = 2.

How do I do this in SQL? I know in ORACLE SQL*PLUS I would use the decode
function. Is there something similar in Access?

[Peter Russell]

Re: Query help

There is no SQL statement to do this (AFAIK).
But in VBA you have Choose (which works to base 1).

MyChoice = Choose(tableNam e.replacement+1 , "No", "Yes", "Don't Know")

Regards

Peter Russell

Mom2B previously wrote:
[color=blue]
> I have a query where I want to retrieve
> "YES" if tableName.repla cement = 1 and
> "NO" if tableName.repla cement = 0 and
> "DONT KNOW" if tableName.repla cement = 2.
>
> How do I do this in SQL? I know in ORACLE SQL*PLUS I would use the
> decode
> function. Is there something similar in Access?
>
>
>[/color]