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

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

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

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