Ranking and Ties

[Guest]

Does anyone know how to create a report that ranks certain values that will
show ties at the same ranking number? For example:
97 1
96 2
95 3
95 3
94 4

 

[Larry Daugherty]

Open the query on which your report is based and make it a totals
query. add a new field Ties: which will have the count.

HTH