how do i write case statement in access database?

C

Conan Kelly

Ragu,

More info please.

Look at a post (and replys) just before yours titled "Transforming an
IF...Then to Case...When" from "Michiel via AccessMonster.com" just about 1
hour before yours (shows up as 10:07 AM my time (Arizona Time...no daylight
savings)). Your post shows as 11:11 AM.

HTH,

Conan
 
J

John W. Vinson

You don't. Case is not supported in JET SQL.

Use the Switch() function instead.
 
Top