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