title: Order by Clause conflicts with distinct in access?
body: <p>Please help me with this as I have been unable to get past this problem</p>
  
  <p>When trying to execute this statement:</p>
  
  <pre><code>SELECT distinct grade
  FROM tblStudents
  ORDER BY Val([grade]),grade;
  </code></pre>
  
  <p>access tells me that <code>ORDER BY</code> clause <code>Val([grade])</code> conflicts with <code>Distinct</code></p>
  
  <p>How can I fix this?</p>
  
  <p>Thank you in advance</p>