microsoft jet sql

[Michelle]

Does Access provide a function equivalent to
Oracle's "decode" function which you use like an
imbedded "if" statement in sql?

 

[Dirk Goldgar]

Does Access provide a function equivalent to
Oracle's "decode" function which you use like an
imbedded "if" statement in sql?

I don't know what Oracle's Decode() function does, but from your
description I'd suggest you have a look at the IIf(), Switch(), and
Choose() functions.

 

[Michelle]

Thank you very much Dirk!

IIf() is reasonably like Decode (enoungh so as to solve my
current problem).

I tried to look up the Switch() function in Help but had
no luck. Is this version specific or does it require a
library or something?

Thanks again,
Michelle

 

[Dirk Goldgar]

Thank you very much Dirk!

IIf() is reasonably like Decode (enoungh so as to solve my
current problem).

I tried to look up the Switch() function in Help but had
no luck. Is this version specific or does it require a
library or something?

No, it's been available at least since Access 97. However, you probably
won't find it unless you look at the VB help, by opening the help file
from the VB Editor.