Ranking data results

[lgrosz]

I need help please with setting up an automated ranking system for
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 t
rank 40 employees in order with multiple employee sharing a scor
sometimes.

Any help would be creatly appreciated; I have been out of this worl
for so long, hope it comes back to me soon.

Thank you!
Le

 

[Dale Fye]

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

 

[lgrosz]

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 descriptio
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?
was thinking a query maybe with an override or just a command butto
that will generate the Rank for reporting.

Les

Would help to know your table structure. It would also help to kno
whether
a 1 or a 10 is best, and how you want the list sequenced, best-to-wors
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

 

[KARL DEWEY]

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.

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

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

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/showthread.php?t=121106)