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