Convert MS SQL query to MS-Access SQL query

[manees]

Just trying to get MS SQL query to work in MS-Access,but I haven't been able to get the query working despite all my tries... can anyone help me to find a guide or tool which convert SQL query to Access SQL query.




Thanks in advance

[JoeM]

Usually, I see requests going the other way.
Does the data reside on a SQL server or Access? If SQL, you could use a Pass-Through Query using the SQL syntax and it should work.
Otherwise, you may want to try posting your code here, so we can see what concepts you are using that might be giving Access trouble.