Top 100 Records and Ties

D

Dona

I want to query the Top 100 scores; however, I want the
ties, too For example, number 100 has a score of 7490. I
want to include the additional 5 records with a 7490
score. This would make the query return 105 records.

Example
SELECT TOP 100[Total Freshmen with Total Academic
Score].PERSON_WH_ID, [Total Freshmen with Total Academic
Score].[Total Academic Score]
FROM [Total Freshmen with Total Academic Score]
ORDER BY [Total Freshmen with Total Academic Score].[Total
Academic Score] DESC;


Is there a way to do this using "Select Top 100 with
ties"? I tried but it didn't work. How would I make this
work with Access 2002 XP?

Suggestions?

Thank you in advance.

Dona
 

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

Top