title: Select TOP N not working in MS Access 2010 Query
body: <p>Its not returning me 1 record as expected.</p>
  
  <pre><code>SELECT TOP 1 ApplicationVersion 
  FROM [All Documents]
  ORDER BY Iif(IsNumeric([ApplicationVersion]), Clng([ApplicationVersion]), 0) DESC
  </code></pre>
  
  <p>Where I'm going wrong?</p>