Ranking

  • Thread starter benton via AccessMonster.com
  • Start date
B

benton via AccessMonster.com

I’m trying to rank the brokers for this month(June) and the previous month
(May) and then I have to find out for how many times has the broker been a
number 1, 2 ,3 or 4 up 10 in a year : Here’s how it should look like

Broker Pos(June) Prev(May) HowMany times in a YR Production
Beverly 1 1 11
968 000
Shana 2 6 8
88000
Benita 3 10 6
76000
Sarita 4 7 2
23000

Please help.
 

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

Ranking 0
Ranking (Look for previous ranking) 3
ranking 0
Decile Ranking 6
Ranking 3
Mapping strings to integers 6
Weighted ranking of a series 3
Create new table from two tables 0

Top