very urgent!!!plz solve this acces query in report tsudio query

[katdbc]

can anyone write it in report studio sql way

this is an accces query

Split: IIf([Detail no VIN]![Year_Month]>"200207","Able to Charge Back",IIf([Unit Vin]![REGULAR_PMT]=0,"Able to Charge Back",IIf(([Detail no VIN]![TOTAL_PAYMENT]/[Unit Vin]![REGULAR_PMT])>11.99,"No Charge Back","Able to Charge Back")))

my answer seems to give only the "able to charge back"
thi is is mine
case
when [2c_reserve_detail].[Year_Months]>'200207' then 'Able to Charge Back'
else (case
when [3_vin_detail].[Scheduled Payment Amount]=0 then 'Able to Charge Back'
else(case
when [2c_reserve_detail].[Total Payment]>11.99 then 'No Charge Back'
else 'Able to Charge Back'
end
)
end
)
end


plz help!!!!thanks in advance

[blom0344]

Looks like you forget to divide by [Unit Vin].[REGULAR_PMT]  in the report Studio SQL ..