- 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;
SELECT TOP 7
Average starting salary & bonus
FROM News Rankings Master
ORDER BY Year DESC;