Top ten sales for each salesman

I'll pose the question like this: I have an Access database, and a table with all the individual sales for five different salesmen. I want a query that will give me the top ten sales for each salesman.

This query, like so many other queries dealing with "top N" results, contains within it the thorny issue of what to do about ties. I'm not even going to mention the issue beyond saying that you should be prepared for the inevitable questions from your users.

In Access, you can use TOP syntax. This makes the necessary correlated subquery a lot easier to write.

Start the conversation

0 comments

Register

I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.

Please check the box if you want to proceed.

I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.