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;
 

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


Back
Top