Using TOP function

Joined
May 14, 2010
Messages
1
Reaction score
0
Please help! I'm newer to access and have been searching the forum but I still can't make this work. I'm trying to use the TOP function to return the 7th highest number of a set (this is like the LARGE function in Excel), sorting by year. Every time I use what Access suggested it doesn't work. Can someone point out where I am going wrong with this?? Thanks!!

SELECT TOP 7
Average starting salary & bonus
FROM News Rankings Master
ORDER BY Year DESC;
 
Back
Top