title: Getting syntax error (missing operator) in query expression in MS Access
body: <p>I get an error message </p>
  
  <blockquote>
    <p>Syntax error (missing operator) in query expression 'r = row_number() over (partition by ACell order by ACell desc)'</p>
  </blockquote>
  
  <p>in Microsoft Access; I don't know why, but it works in Microsoft SQL Server.</p>
  
  <p>My query:</p>
  
  <pre><code>select * 
  from 
      (select *, r = row_number() over (partition by ACell order by ACell 
      desc) 
      from cellTB) a 
  where 
      r &lt;= 5;
  </code></pre>
  
  <p>Please could anyone help me?</p>
  
  <p>Example Data: cellTB</p>
  
  <pre><code>=================
  ACell  |   RNC
  =================
  1      |   1
  -----------------
  1      |   2
  -----------------
  1      |   3
  -----------------
  1      |   4 
  -----------------
  1      |   5
  -----------------
  1      |   6
  -----------------
  2      |   1
  -----------------
  2      |   2
  -----------------
  2      |   3
  -----------------
  2      |   4
  -----------------
  2      |   5
  -----------------
  2      |   6
  </code></pre>
  
  <p>I want to select just top 5 from duplicate ACell in MC Access.</p>