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

Sorting and filtering text 0
Grow/Shrink Text gradually from slide to slide 0
Start/finish but work is only a couple hours 1
Like to start using Access 1
Slideshow with black border around it 0
Averages for Multiple Types 5
query return only one row with averages 4
Getting the graph style I want 4

Top