sqlms-accessms-access-2013

Microsoft Access can't represent the join expression "<=" operators


I have the following SQL

SELECT 
a.StudentsID, 
a.ClassGroup, 
a.FinalGrade, 
COUNT(*) AS ranknumber

FROM FinalAVG AS a 
INNER JOIN FinalAVG AS b 
ON (a.ClassGroup = b.ClassGroup) 
AND (a.FinalGrade <= b.FinalGrade)

GROUP BY 
a.ClassGroup, 
a.StudentsID, 
a.FinalGrade

HAVING COUNT(*) <= 3
ORDER BY a.ClassGroup, COUNT(*) DESC; 

It works well. However when I switch to design view, it shows me the following error

Microsoft Access can't represent the join expression a.FinalGrade <= 
b.FinalGrade

Any help please ?


Solution

  • That's by design and a limitation of the GUI designer.

    However, the SQL view is available for this type of queries.

    Yes, just go ahead and correct errors if any. As is, your SQL seems valid.