In need of ranking with ties in report

[burnfly]

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!!

 

[Beetle]

You might find this page helpful. You might actually want to just bookmark Allen's site. Lots of useful info there.

 

[burnfly]

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.

 

[Brianwarnock]

I usually do ranking in the query so have not done this but what happens if you make it >= not just >

Brian

 

[burnfly]

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.

 

[Brianwarnock]

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

 

[burnfly]

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