microsoft jet sql

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

Does Access provide a function equivalent to
Oracle's "decode" function which you use like an
imbedded "if" statement in sql?
 
Michelle said:
Does Access provide a function equivalent to
Oracle's "decode" function which you use like an
imbedded "if" statement in sql?
Click to expand...

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.
 
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
 
Michelle said:
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?
Click to expand...

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.
 
Back
Top