Case when

[krufruf]

Hi. Hoping for some help. I'm used to doing all my querying in DB2 QMF/SQL and the language is slightly different than SQL in Access. Can anyone please tell me how to use CASE WHEN statements in Access? Below is a case statement from QMF SQL that I need to replicate in Access. ANY help would be appreciated. I tried copying this to Access SQL and it won't work. THanks!

SELECT LAST_NAME,COUNT(DISTINCT CLAIMS) AS CLAIMCTS,
(CASE WHEN STATE IN ('IN','OH') THEN 'CENTRAL'
ELSE 'OTHER' END) AS REGION
(CASE WHEN METH_CODE='T' THEN 'PHONE'
WHEN METH_CODE='E' THEN 'EMAIL'
ELSE 'OTHER' END) AS METH
FROM TABLE 1


WHERE DATE BETWEEN '2012-07-01' AND '2012-07-14'
GROUP BY LAST_NAME,STATEK_METH_CODE

[JoeM]

I believe that you can only use CASE statements in VBA in Access, not directly in the queries.
You will either need to use something else, like Immediate IF statements (IIF), or create a User Defined Function (UDF) to use.
Your statements look pretty basic, and you should be able to use IIF (hor help of IIF: http://www.techonthenet.com/access/f...vanced/iif.php).

[krufruf]

Thank you much!