Hi,
The question below was posted about 4 years ago and noone was able to
answer it back then. I have virtually the same type of problem so would
appreciate if anyone can help.
Thanks
================================================== ====================
I have read through multiple posts on ranking records in an Access
query but have not been able to located one that addresses my scenario
exactly.
I have a query that pulls potential customers by geographic territory
and provides a total market potential for each customer shown as unit
sales.
The query ranks the territories in ascending order and the market
potential in descending order so that I wind up with territory #1 and
the highest potential customer as the first record followed by every
customer in the territory is descending potential order, e.g.
Territory Cust Potential (Unit Sales)
1000 200
1000 178
1000 143
..
..
1001 225
1001 197
etc.
Total record count is 377,630. I need to rank each customer based on
their potential within each territory so that my query winds up with
the following
Territory Cust Potential (Unit Sales) Rank
1000 200 1
1000 178 2
1000 143 3
..
..
1001 225 1
1001 197 2
Any assistance is greatly appreciated.
================================================== ====================