Ranking values in a report

[Wayne Zabel]

I have made a report that displays the count of times a person has won an
event. It also shows the name and winnings.
I have several thousand people being tracked and there are obviously
duplicate numbr of time various individuals have wou.

For example

Count Player Winnings
84 ABC $5,000,000.00
---------------------------
79 DEF $4,000,000.00
79 GHI $4,500,000.00
---------------------------
70 JKL $3,000,000.00

What I need is to rank the individuals and show ties.

For example
Count Player Winnings Rank
84 ABC $5,000,000.00 1

 

[Allen Browne]

See:
Ranking or numbering records
at:
http://allenbrowne.com/ranking.html
The article explains how to use a subquery to rank in a query.

It also suggests that you turn this into an Append query and write the data
to a temporary table, which you use as the source for your report. (You will
find this necessary if you want to do any sorting or grouping of the data in
the report.)

 

[Wayne]

Thanks for the quick response. You have solved my problem.
Wayne

See:
Ranking or numbering records
at:
http://allenbrowne.com/ranking.html
The article explains how to use a subquery to rank in a query.

It also suggests that you turn this into an Append query and write the
data to a temporary table, which you use as the source for your report.
(You will find this necessary if you want to do any sorting or grouping of
the data in the report.)