title: How to get the best 10 (top 10) in a query that is also ordered by another field first?
body: <p>For example I would like to get only the top 10 customer by seller. So it will look like this (without the top 10):</p>
  
  <pre><code>Select seller, customer, sells from table order by seller asc, sells desc
  </code></pre>
  
  <p>But this will give me all the values. I would only like to have the first 10 customers for each seller.</p>
  
  <p>Is this even possible in ms-access 2003? If yes, please give me a hint,
  thanks ;)</p>