|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 4th, 2009, 07:13 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Select Top Values within each group
I am using Access 2007. I would like to create a query that returns top 50
customers for each Sales Rep. I tried creating a total query, sorted the sales in descending order and used the "Return" tool in the Design tab. The results are only the top 50 for the entire sales force, not each sales representative. Is there a way to do this? 
|
|
#2
August 4th, 2009, 08:35 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Select Top Values within each group
Check out the following and see if that helps.
http://allenbrowne.com/subquery-01.html#TopN John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County KrispyData wrote: I am using Access 2007. I would like to create a query that returns top 50 customers for each Sales Rep. I tried creating a total query, sorted the sales in descending order and used the "Return" tool in the Design tab. The results are only the top 50 for the entire sales force, not each sales representative. Is there a way to do this?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
