CASE WHEN

  • Thread starter Thread starter Al
  • Start date Start date
A

Al

Hi all,

Doesn't "CASE WHEN" clause work JET SQL of Access 2000?
I'm going crazy about this issue, isn't there any
replacement I could use?

Thanks a lot.
 
Not AFAIK. Try the IIF(Immediate-IF) function.

Check Access VB Help on IIF function.
 
Thanks a lot friends. You've been so helpful. And Lynn,
you have a great website about Access security...

Al
 
Hi all,

Doesn't "CASE WHEN" clause work JET SQL of Access 2000?
Click to expand...

No, it doesn't.
I'm going crazy about this issue, isn't there any
replacement I could use?
Click to expand...

Take a look at the SWITCH function:

CalcField: Switch(Logical-Expression, ValueIfTrue, Logical-Expression,
ValueIfTrue, Logical-Expression, ValueIfTrue, TRUE, FinalValue)

Its arguments come in pairs; it will return the second member of the
first pair for which the first member evaluates to TRUE.
 
Back
Top