DCount question - consecutive rank with ties

[burnfly]

Hello all. I have some queries that rank with DCount and show ties like this - 1,2,2,4,5,5,5,8...

Is there a way to get a rank that would look like this instead?
1,2,2,3,4,4,4,5

The change would be that the numbering stays consecutive, instead of jumping to the next "number of record".

This is what I use in the query to get the first mentioned result =
DCount("Score","qryScores","Score>" & [Score])+1)

Thanks in advance!!

 

[gemma-the-husky]

i am sure you could do it - just modify the version you have to identify the UNIQUE scores and do the placements that way.

The point is though that if you have scores of 90, 88, 88, 85 - then the persons scoring 88 are tied 2nd and 3rd, and the person scoring 85 is clearly 4th, not 3rd.

 

[burnfly]

Thanks for the reply GtH.

Wait... "just modify the version you have to identify the UNIQUE scores". ?? Not exactly sure what you mean (please excuse my novice-ness).

However, I do not need to know who the "4th placed person is" - I need to know who tied for the 2nd highest score, and then who got the 3rd highest score (or tied for it), etc...

Thanks again!!

 

[Brianwarnock]

I've lost track of what you are trying to do, are you just wanting to change the numbers or get some other information based on the numbers.

Don't think I can help either way but who knows.

Brian

 

[burnfly]

GtH - your post sparked my thought. I was able to achieve my desired results by creating a group query with *only* the scores (grouping the score numbers). Then I was able to create another query that distinct-counts those grouped scores. It works.

Thanks yet again!

 

[burnfly]

Brian, I now have a rank within a query that displays ties and orders sequencially like this = 1,2,2,2,3,3,4,5,5,6,6, etc...