case statement in sql not working

trying to do a pass through query in Access 2010.

SELECT DISTINCT dbo_t_dispensing_metrics_detail_schedules.Account_Number, 
t_dispensing_metrics_header.Corp_MA_Start_Date, 
t_dispensing_metrics_header.Corp_MA_End_Date, 
t_dispensing_metrics_header.Exempt_From_Terms, 
t_dispensing_metrics_header.Exempt_From_Fee, 
dbo_t_dispensing_metrics_detail_schedules.Exempt_From_Fee_Schedule, 
dbo_t_dispensing_metrics_detail_schedules.Exempt_From_Terms_Schedule,
Case When Fee-Implemented like ‘Yes%’ or Fee-Implemented like ‘Both%’  then ‘Yes’
else ‘No’
END as 'Service Charge'
FROM t_dispensing_metrics_header INNER JOIN dbo_t_dispensing_metrics_detail_schedules ON t_dispensing_metrics_header.Contract_Number_DISP_MA = dbo_t_dispensing_metrics_detail_schedules.Contract_Number_DISP_MA
WHERE dbo_t_dispensing_metrics_detail_schedules.Account_Number Is Not Null 
AND t_dispensing_metrics_header.Exempt_From_Terms=Null 
AND t_dispensing_metrics_header.Exempt_From_Fee =Null AND 
dbo_t_dispensing_metrics_detail_schedules.Exempt_From_Fee_Schedule Is Null 
AND dbo_t_dispensing_metrics_detail_schedules.Exempt_From_Terms_Schedule Is Null
ORDER BY dbo_t_dispensing_metrics_detail_schedules.Account_Number;

Select allOpen in new window

Can't get the syntax correct ?

Thanks
fordraiders