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
|
|||
|
|||
Rank Scorecard Results
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 |
#2
|
|||
|
|||
See:
How to Rank Records Within a Query at: http://support.microsoft.com/default...b;en-us;208946 -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Ndel40" wrote in message ... 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 |
#3
|
|||
|
|||
It worked... Thanks!
"Allen Browne" wrote: See: How to Rank Records Within a Query at: http://support.microsoft.com/default...b;en-us;208946 -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Ndel40" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to get rank numbers for Top results | BG | Running & Setting Up Queries | 9 | September 13th, 2004 02:05 PM |
Repost: Calculation problem. Someone help! | Victor | Running & Setting Up Queries | 13 | August 6th, 2004 05:21 PM |
Help with Queries and codes | WSUHoss3 | General Discussion | 11 | July 19th, 2004 11:35 AM |
RANK formula question | Tom Wright | Worksheet Functions | 4 | December 16th, 2003 08:17 AM |