Yeh Noel, I hear ya. Just wanted to maybe give you some "ammo" or thoughts that might help. 
Is the statement hard coded into an app some where, and is now being issued to SQLSrv. instead of Access?
Once you understand the BITs, all the pieces come together 