K
KrispyData
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?
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?