Case Statement for MS Access Query

Dear EE members,

I would like to convert the following sql server query to ms access query:

select  grade
= case
when pcode1 in ('A01','A12','A17','A34') then 'P'
when pcode1 in('A08','A09') then 'U'
when pcode1 in ('A10','A11','A12','A17','A34') then 'R'
END from dbo.Prod;

TQ.

Rgds,
PeterStart Free Trial