Convert SQL Server Query to Access Query

[Juan4412]

How would I run this SQL Server query in an Access Query?

Select a.employee_name, Count(b.employee_name)
From dbo.info a
Left Join dbo.Master b
On b.employee_name = a.employee_name
And b.sick_day Between '2013-03-01' And '2013-03-31'
Group By a.employee_name

[pbaldy]

As a pass through query it can run as-is. In an Access query, you'd want # instead of ' as a delimiter for the dates, and you wouldn't want the dbo. before the table names.

[Juan4412]

What do you mean a pass through query?

This query when I attempt to run in access, tells me there is an error in my JOIN statement. Maybe that is what you meant as a pass through query.

EDIT
The actual error is JOIN expression not supported.

[pbaldy]

I don't see a problem. Just tested and this ran fine (Access query against linked SQL Server tables):

SELECT B.EmpNum, B.DocCert, A.EmpLastName
FROM tblHRData A LEFT JOIN tblEmpDocCert B ON A.EmpNum = B.EmpNum

Can you post your db here?

[pbaldy]

Sorry, a pass through query is one that has a connection string and it simply passes the SQL to the back end, in this case SQL Server. In that type of query, you would still use T-SQL.