Problem with select and case stamenet 1

[morfasie]

I have this statement :
SELECT sum(CASE WHEN `Agent Code` LIKE '%GB01%' THEN Premium END ) AS 'Tswane Soweto',
sum(CASE WHEN `Agent Code` LIKE '%WW02%' THEN Premium END ) AS 'North West Moretele',
sum(CASE WHEN `Agent Code` LIKE '%WW02%' THEN Premium END ) AS 'North West Odi',
sum(CASE WHEN `Agent Code` LIKE '%GA01%' THEN Premium END ) AS 'Tswane PTA'
FROM production

but I want to put a where in ('PTA','JHB') intot every case statement. Where do I put it with the above?

thanks

 

[PHV]

Why not just add a WHERE clause after the FROM one ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[FederalProgrammer]

Do u know if we can use
CASE When cond Then END
in MS Access??

 

[PHV]

Take a look at the IIf function.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884