CASE WHEN

[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.

 

[Lynn Trapp]

In Jet SQL you need to use either Switch() or IIF()

 

[Van T. Dinh]

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

Check Access VB Help on IIF function.

 

[Al]

Thanks a lot friends. You've been so helpful. And Lynn,
you have a great website about Access security...

Al

 

[John Vinson]

Hi all,

Doesn't "CASE WHEN" clause work JET SQL of Access 2000?

No, it doesn't.

I'm going crazy about this issue, isn't there any
replacement I could use?

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.

 

[Lynn Trapp]

You're quite welcome, and thanks for the compliment on the site.