MS SQL QUERY To ms access query : I need following query to work with MS Access.

select  (left(x, Charindex('.', x, 1) - 1))As 'CRT', 
		Cast(ROUND((ABS(x) - FLOOR(ABS(x)))* cf,1) as float) As 'PCs'
from (
    select 36 * 1.0 / 36 as x, 36 as cf
) t