Using Case

M

Michael Marquardt

Does Access suport the use of CASE in queries? I want to
avoid multiple iif statement and replace them with CASE.
Can I do this?
Thanks
 
J

John Vinson

Does Access suport the use of CASE in queries? I want to
avoid multiple iif statement and replace them with CASE.
Can I do this?
Thanks
Click to expand...

Not with CASE (unless it's been added in 2003); however you can use
the Switch() function in place of a multilevel IIF.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top