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
|
|||
|
|||
Ranking data results
I need help please with setting up an automated ranking system for a list of data. For example I have a list of employees that are "scored" on quality, say on a scale of 1 thru 10, based on the score I need to rank 40 employees in order with multiple employee sharing a score sometimes. Any help would be creatly appreciated; I have been out of this world for so long, hope it comes back to me soon. Thank you! Les -- lgrosz ------------------------------------------------------------------------ lgrosz's Profile: http://www.thecodecage.com/forumz/member.php?userid=593 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121106 |
#2
|
|||
|
|||
Ranking data results
Would help to know your table structure. It would also help to know whether
a 1 or a 10 is best, and how you want the list sequenced, best-to-worst or worst-to-best. Something like the following would work: SELECT T.EmpID, T.EmpName, T.Quality, DCOUNT("EmpID", "yourTable", "[Quality] = " & T.Quality) as Rank FROM yourTable as T ORDER BY T.Quality ---- HTH Dale "lgrosz" wrote: I need help please with setting up an automated ranking system for a list of data. For example I have a list of employees that are "scored" on quality, say on a scale of 1 thru 10, based on the score I need to rank 40 employees in order with multiple employee sharing a score sometimes. Any help would be creatly appreciated; I have been out of this world for so long, hope it comes back to me soon. Thank you! Les -- lgrosz ------------------------------------------------------------------------ lgrosz's Profile: http://www.thecodecage.com/forumz/member.php?userid=593 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121106 |
#3
|
|||
|
|||
Ranking data results
Thank you Dale! Like I said, it's been quite awhile. Of course you can't see what I am working on so my broad description was a laugh. 1 is the best out of 10. EmployeeID - QualityScore1 - AdherenceScore2 - #of CallsScore3 - Rank EmployeeID - QualityScore1 - AdherenceScore2 - #of CallsScore3 - Rank EmployeeID - QualityScore1 - AdherenceScore2 - #of CallsScore3 - Rank All is in one table at this point for ease and it won't be expanding. The Rank will also need to be overriden by a supervisor. Lovely, huh? I was thinking a query maybe with an override or just a command button that will generate the Rank for reporting. Les Dale Fye;436302 Wrote: Would help to know your table structure. It would also help to know whether a 1 or a 10 is best, and how you want the list sequenced, best-to-worst or worst-to-best. Something like the following would work: SELECT T.EmpID, T.EmpName, T.Quality, DCOUNT("EmpID", "yourTable", "[Quality] = " & T.Quality) as Rank FROM yourTable as T ORDER BY T.Quality ---- HTH Dale "lgrosz" wrote: I need help please with setting up an automated ranking system for a list of data. For example I have a list of employees that are "scored" on quality, say on a scale of 1 thru 10, based on the score I need to rank 40 employees in order with multiple employee sharing a score sometimes. Any help would be creatly appreciated; I have been out of this world for so long, hope it comes back to me soon. Thank you! Les -- lgrosz ------------------------------------------------------------------------ lgrosz's Profile: 'The Code Cage Forums - View Profile: lgrosz' (http://www.thecodecage.com/forumz/member.php?userid=593) View this thread: 'Ranking data results - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...d.php?t=121106) -- lgrosz ------------------------------------------------------------------------ lgrosz's Profile: http://www.thecodecage.com/forumz/member.php?userid=593 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121106 |
#4
|
|||
|
|||
Ranking data results
I am guessing that Dale's post did not solve your requirement.
Why did you post back that the table also has [AdherenceScore2] and [#of CallsScore3] ? Are they suppose to figure in the mix? If so, then how? -- Build a little, test a little. "lgrosz" wrote: Thank you Dale! Like I said, it's been quite awhile. Of course you can't see what I am working on so my broad description was a laugh. 1 is the best out of 10. EmployeeID - QualityScore1 - AdherenceScore2 - #of CallsScore3 - Rank EmployeeID - QualityScore1 - AdherenceScore2 - #of CallsScore3 - Rank EmployeeID - QualityScore1 - AdherenceScore2 - #of CallsScore3 - Rank All is in one table at this point for ease and it won't be expanding. The Rank will also need to be overriden by a supervisor. Lovely, huh? I was thinking a query maybe with an override or just a command button that will generate the Rank for reporting. Les Dale Fye;436302 Wrote: Would help to know your table structure. It would also help to know whether a 1 or a 10 is best, and how you want the list sequenced, best-to-worst or worst-to-best. Something like the following would work: SELECT T.EmpID, T.EmpName, T.Quality, DCOUNT("EmpID", "yourTable", "[Quality] = " & T.Quality) as Rank FROM yourTable as T ORDER BY T.Quality ---- HTH Dale "lgrosz" wrote: I need help please with setting up an automated ranking system for a list of data. For example I have a list of employees that are "scored" on quality, say on a scale of 1 thru 10, based on the score I need to rank 40 employees in order with multiple employee sharing a score sometimes. Any help would be creatly appreciated; I have been out of this world for so long, hope it comes back to me soon. Thank you! Les -- lgrosz ------------------------------------------------------------------------ lgrosz's Profile: 'The Code Cage Forums - View Profile: lgrosz' (http://www.thecodecage.com/forumz/member.php?userid=593) View this thread: 'Ranking data results - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...d.php?t=121106) -- lgrosz ------------------------------------------------------------------------ lgrosz's Profile: http://www.thecodecage.com/forumz/member.php?userid=593 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121106 |
Thread Tools | |
Display Modes | |
|
|