top 3 averages

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?
 
J

John W. Vinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Averages for Multiple Types 4
query return only one row with averages 4
played win percentage for averages for a league. 1
Averages 5
Query/Reports - looking to get averages from data base 4
Help...Want to make integer down to hundreth in qry. 2
Calculating an average across multiple fields 7
Averaging data in two different tables 3

Top