title: Access SQL: using MIN() function with subquery
body: <p>I'm trying to calculate the 90th percentile on a column of my data. MS Access doesn't have a PERCENTILE function, so I'm taking the top 100 values (of 1000 in total), and then taking the minimum of the values that are returned. I'm however having some difficulty using the MS Access MIN() function. My query currently looks as follows:</p>
  
  <pre><code>SELECT MIN(*) 
  FROM (SELECT TOP 100 ([table1].[field1] + [table1].[field2]) FROM [table1]);
  </code></pre>
  
  <p>This gives me the error:</p>
  
  <pre><code>Syntax error (missing operator) in query expression 'MIN(*'.
  </code></pre>
  
  <p>Why am I not allowed to use the asterisk with the MIN function? Am I calculating this value completely incorrectly? </p>