Re: [MS_AccessPros] RANKING

 

Thanks Eric. It's not SORTING I am talking about but RANKING. The ranking field is a calculated control I am trying to achieve in Access and for which I need help. I included it to show the desired final result.

 

Ade.

---

From: "Barry White imtigerwords@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: yahoogroups <ms_access_professionals@yahoogroups.com>; MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, 13 April 2016, 1:36
Subject: Re: [MS_AccessPros] RANKING

 

It appears the lower the score the better, like in the sport golf, which I cannot play very well.

If the SCORE column is how you are evaluating ranking, then usually the higher the score the better (like on test scores in school). But it looks like the lower the score the better in this ranking example.

But personally, when I do a ranking, I would not give Excel and Notepad both a 4.5, they would each get a ranking of 4 from me. I would leave ranks at whole numbers. But they are right whoever did this, you would then jump from a ranking of 4 to a ranking of 6 for Harry, since there were two names tied with the same 4 score.

As an aside, the other way I do rankings is that I take the scores, whatever they happen to be, and if the HIGHEST score is considered better, whatever that highest score happens to be, I set it artificially as my 100% or as the denominator. So every subsequent score that is lower than the highest score would have the following formula:

Tom 98
Dick 55
Harry 75
Outlook 58
Excel 70
Publisher 61
Notepad 70

Tom = 100% or 100
Harry's formula would be (75 / 98) * 100
Outlooks formula would be (58 / 98) * 100
etc,

This way you can see just how far behind the followers are from the leader in terms of percentage differential.

Eric Lutz

--------------------------------------------
On Tue, 4/12/16, Adeboyejo Oyenuga aoye_99@yahoo.co.uk [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Subject: [MS_AccessPros] RANKING
To: "yahoogroups" <ms_access_professionals@yahoogroups.com>
Date: Tuesday, April 12, 2016, 7:41 PM


 









Hi All,
would
you give a hint as to the achievement of RANK as in column 3
in the query grid if the information in columns 1 & 2
are available ?
Pls
see below.
Thanks.
Ade
StudentNameScoreRankTom987Dick551Harry756Outlook582Excel704.5Publisher613Notepad704.5









#yiv1361616416 #yiv1361616416 --
#yiv1361616416ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv1361616416 #yiv1361616416ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv1361616416 #yiv1361616416ygrp-mkp #yiv1361616416hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv1361616416 #yiv1361616416ygrp-mkp #yiv1361616416ads {
margin-bottom:10px;}

#yiv1361616416 #yiv1361616416ygrp-mkp .yiv1361616416ad {
padding:0 0;}

#yiv1361616416 #yiv1361616416ygrp-mkp .yiv1361616416ad p {
margin:0;}

#yiv1361616416 #yiv1361616416ygrp-mkp .yiv1361616416ad a {
color:#0000ff;text-decoration:none;}
#yiv1361616416 #yiv1361616416ygrp-sponsor
#yiv1361616416ygrp-lc {
font-family:Arial;}

#yiv1361616416 #yiv1361616416ygrp-sponsor
#yiv1361616416ygrp-lc #yiv1361616416hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv1361616416 #yiv1361616416ygrp-sponsor
#yiv1361616416ygrp-lc .yiv1361616416ad {
margin-bottom:10px;padding:0 0;}

#yiv1361616416 #yiv1361616416actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv1361616416 #yiv1361616416activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv1361616416 #yiv1361616416activity span {
font-weight:700;}

#yiv1361616416 #yiv1361616416activity span:first-child {
text-transform:uppercase;}

#yiv1361616416 #yiv1361616416activity span a {
color:#5085b6;text-decoration:none;}

#yiv1361616416 #yiv1361616416activity span span {
color:#ff7900;}

#yiv1361616416 #yiv1361616416activity span
.yiv1361616416underline {
text-decoration:underline;}

#yiv1361616416 .yiv1361616416attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv1361616416 .yiv1361616416attach div a {
text-decoration:none;}

#yiv1361616416 .yiv1361616416attach img {
border:none;padding-right:5px;}

#yiv1361616416 .yiv1361616416attach label {
display:block;margin-bottom:5px;}

#yiv1361616416 .yiv1361616416attach label a {
text-decoration:none;}

#yiv1361616416 blockquote {
margin:0 0 0 4px;}

#yiv1361616416 .yiv1361616416bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv1361616416 .yiv1361616416bold a {
text-decoration:none;}

#yiv1361616416 dd.yiv1361616416last p a {
font-family:Verdana;font-weight:700;}

#yiv1361616416 dd.yiv1361616416last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv1361616416 dd.yiv1361616416last p
span.yiv1361616416yshortcuts {
margin-right:0;}

#yiv1361616416 div.yiv1361616416attach-table div div a {
text-decoration:none;}

#yiv1361616416 div.yiv1361616416attach-table {
width:400px;}

#yiv1361616416 div.yiv1361616416file-title a, #yiv1361616416
div.yiv1361616416file-title a:active, #yiv1361616416
div.yiv1361616416file-title a:hover, #yiv1361616416
div.yiv1361616416file-title a:visited {
text-decoration:none;}

#yiv1361616416 div.yiv1361616416photo-title a,
#yiv1361616416 div.yiv1361616416photo-title a:active,
#yiv1361616416 div.yiv1361616416photo-title a:hover,
#yiv1361616416 div.yiv1361616416photo-title a:visited {
text-decoration:none;}

#yiv1361616416 div#yiv1361616416ygrp-mlmsg
#yiv1361616416ygrp-msg p a span.yiv1361616416yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv1361616416 .yiv1361616416green {
color:#628c2a;}

#yiv1361616416 .yiv1361616416MsoNormal {
margin:0 0 0 0;}

#yiv1361616416 o {
font-size:0;}

#yiv1361616416 #yiv1361616416photos div {
float:left;width:72px;}

#yiv1361616416 #yiv1361616416photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv1361616416 #yiv1361616416photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv1361616416 #yiv1361616416reco-category {
font-size:77%;}

#yiv1361616416 #yiv1361616416reco-desc {
font-size:77%;}

#yiv1361616416 .yiv1361616416replbq {
margin:4px;}

#yiv1361616416 #yiv1361616416ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv1361616416 #yiv1361616416ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv1361616416 #yiv1361616416ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv1361616416 #yiv1361616416ygrp-mlmsg select,
#yiv1361616416 input, #yiv1361616416 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv1361616416 #yiv1361616416ygrp-mlmsg pre, #yiv1361616416
code {
font:115% monospace;}

#yiv1361616416 #yiv1361616416ygrp-mlmsg * {
line-height:1.22em;}

#yiv1361616416 #yiv1361616416ygrp-mlmsg #yiv1361616416logo {
padding-bottom:10px;}


#yiv1361616416 #yiv1361616416ygrp-msg p a {
font-family:Verdana;}

#yiv1361616416 #yiv1361616416ygrp-msg
p#yiv1361616416attach-count span {
color:#1E66AE;font-weight:700;}

#yiv1361616416 #yiv1361616416ygrp-reco
#yiv1361616416reco-head {
color:#ff7900;font-weight:700;}

#yiv1361616416 #yiv1361616416ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv1361616416 #yiv1361616416ygrp-sponsor #yiv1361616416ov
li a {
font-size:130%;text-decoration:none;}

#yiv1361616416 #yiv1361616416ygrp-sponsor #yiv1361616416ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv1361616416 #yiv1361616416ygrp-sponsor #yiv1361616416ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv1361616416 #yiv1361616416ygrp-text {
font-family:Georgia;}

#yiv1361616416 #yiv1361616416ygrp-text p {
margin:0 0 1em 0;}

#yiv1361616416 #yiv1361616416ygrp-text tt {
font-size:120%;}

#yiv1361616416 #yiv1361616416ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv1361616416

__._,_.___

---

Posted by: Adeboyejo Oyenuga <aoye_99@yahoo.co.uk>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (3)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___