SELECT CASE with MS Access ?

[dbelley_office]

Hi,

Is is possible to use the Select case in MS Access ?

If yes, what is wrong with this query.

SELECT NOPLAINTE, NOPOCKET, 
CASE PLAIDOYER 
WHEN 'Coupable' THEN '1'
WHEN 'Non coupable' THEN '2'
WHEN 'Bénéfice du doute' THEN '3'
END
FROM PLAINTES 
ORDER BY NOPLAINTE

Thanks.