Rank Scorecard Results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that creates a scorecard and sorts the results in desending
order. I would like to assign a ranking based on the results. Below is an
exmple of how I would like the ranking to look:

Note: The Query Name is Scorecard Query2 - Rank and the field names are LTO
& Pts Overall.

LTO Pts Overall Rank
AMT0930 100 1
MXS5756 100 1
REE1622 100 1
AZS2818 95 4
CEH1437 95 4
AMC8863 90 6
DKB4051 90 6
DMN7639 90 6
EJB0709 90 6
JKB6303 90 6
JZB5188 90 6
SZN7102 90 6
BEL9418 85 13
ELD9881 85 13
JBS5941 85 13


Thanks,

Nick
 
Back
Top