将sqlserver查询转换为Ms Access?

I have this query on sql server which i use in my reporting services now i need to convert it to local report(rdlc) and use ms access as backend. I have this query on sql server which i use in