Left Join query not working in Access 2010

E

Eric Heinold

Hello,

I have a query that works correctly in Access 2003, but not in Access 2010.
Here is the SQL:

SELECT qrySysSelectEeSS.EmployeeID, qrySysSelectEeSS.Name,
qrySysSelectEeSS.ListOrder, Sum(IIF(tblPRItem.Preserve,1,0)) As
CountOfPreserved FROM (qrySysSelectEeSS INNER JOIN tblPRItemPayWork ON
qrySysSelectEeSS.EmployeeID = tblPRItemPayWork.EmployeeID) LEFT JOIN
tblPRItem ON tblPRItemPayWork.EmployeeID = tblPRItem.EmployeeID WHERE
((tblPRItemPayWork.RunTypeID = 44) And (qrySysSelectEeSS.Active=True)) GROUP
BY qrySysSelectEeSS.Name, qrySysSelectEeSS.EmployeeID,
qrySysSelectEeSS.ListOrder ORDER BY qrySysSelectEeSS.ListOrder;

If I remove the LEFT JOIN from the query, Access 2010 returns the correct
records, but I need to be able to use it. Is this a known issue in Access
2010?

Thanks,

Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set as Default Template not working 0
Query Join - Outer Join? 5
JOIN Query very slow 4
query help 2
perform INNER JOIN on query results 2
Migrating from 2010 to 2013 - having issues: Exporting to xml 0
In Access 2010, how do I create a SQL query? 1
Help with a simple query 3

Top