title: Access 2010 Limit Query Results
body: <p>What's the syntax in MS Access 2010 for limiting the results of a query to the first 1,000?</p>
  
  <p>I've tried this</p>
  
  <pre><code>SELECT tblGL.[Cost Centre Code]
  FROM tblGL
  LIMIT 1000;
  </code></pre>
  
  <p>but I get the error 'Syntax error in FROM clause'.</p>
  
  <p>I've also tried setting the Max Records property but it doesn't seem to do anything - I still get 7,000+ results regardless of what value I enter into the Max Records field.</p>
  
  <p>I also want to have a 2nd query which selects the next 25,000, starting from the 1,001st. Something like:</p>
  
  <pre><code>SELECT tblGL.[Cost Centre Code]
  FROM tblGL
  LIMIT 1001, 25000;
  </code></pre>