Using Case

  • Thread starter Thread starter Michael Marquardt
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Support for CASE statements in SQL 2
Double Trouble with Alias Columns & Nested Case When in APD/SQLDatabase 1
Time in calculated field for shifts going past midnight 0
Nested If conversion to Select case 5
Multiple IIf's 6
using CASE in access 5
Can you use query fields as function variables? 6
Query Question regarding IIf's 5

Back
Top