top 3 averages

  • Thread starter Thread starter alm09
  • Start date Start date
A

alm09

I have a query that averages the scores of 16 people. I would like to run a
second query that will give me only the top 3 averages out of the 16. How can
I do this?
 
I have a query that averages the scores of 16 people. I would like to run a
second query that will give me only the top 3 averages out of the 16. How can
I do this?
Click to expand...

Set the TOP VALUES property of your query to 3.

Post the SQL of the query if you need help doing so.
 
Back
Top