In need of ranking with ties in report

burnfly

Registered User.
Local time
Today, 13:22
Joined
Feb 6, 2013
Messages
29
I have a report in which I am ranking a group (sorted scores) by using a text box with a running sum. This works, however I'm needing it to display ties according to scores (i.e. 1,2,2,4) - it doesn't display any ties as it's just counting the records, not really 'ranking'.

I do know how to display ties within a query via DCount. I'm not sure I can build the report I need (that I'm currently using) from a query that ranks with DCount. Too many divisions of information. The report is sorting and grouping things and I need to rank them after those sorts and groups.

Anyone know of a method to rank in a report that functions the way DCount works in a query? i.e. This is what I use in the query that gives me the ranks I need to see... Place: DCount("Score","qryScores","Score>"&[Score])+1

TIA!!
 
You might find this page helpful. You might actually want to just bookmark Allen's site. Lots of useful info there.
 
Thanks for your reply Sean. I've googled (and googled!) and seen that page before. The main thing I'm seeing in a report ranking is a running sum counting the records. However, I actually need to see the ties if possible.
 
I usually do ranking in the query so have not done this but what happens if you make it >= not just >

Brian
 
Brian - I am not using any formula in the report. I *do* have some ranking queries not related to the report that I need to rank in which I use DCount (with>) for correct results within those queries. What I need to know, is if there is a way I can use a formula within a *report* to show me those ranking results. ? I have a report with hundreds of divisions and sorts in which I need to rank all those divisions by a set of scores. I am able to do a very basic rank by using a "running sum" which is just counting the records. What I'd like, is an actual rank that is comparing the scores.
 
I have no idea how to do this in a report I thought that you were using Dcount in the report but having reread your first post I see that I was mistaken, sorry.
I've always been able to do the ranking in the queries the report is based on.

Brian
 
No sweat Brian, I appreciate your reply regardless. Yup.
 

Users who are viewing this thread

Back
Top Bottom