title: Multi-level GROUP BY clause not allowed in subquery
body: <p>I have a query as follows in MS Access</p>
  
  <pre><code>SELECT tblUsers.Forename, tblUsers.Surname, 
    (SELECT COUNT(ID) 
       FROM tblGrades 
       WHERE UserID = tblUsers.UserID 
       AND (Grade = 'A' OR Grade = 'B' OR Grade = 'C')) AS TotalGrades
  FROM tblUsers
  </code></pre>
  
  <p>I've put this into a report and now when trying to view the report it displays an alert "<strong>Multi-level GROUP BY clause is not allowed in subquery</strong>"</p>
  
  <p>What I dont get is I dont even have any GROUP BY clauses in the query so why is it returning this error?</p>