how do i rank on report

[_Bigred]

I have a report that is based on a query


The query is as follows:

Author Author
Group By Sum (sort descending)



This gives me the following type of info on my report

Doe, John 101
Smith, Sally 99
Schmoe, Bob 73
Doe, Sally 73

I can get it to layout like the data above on my report, but want to
add a unbound text box (=1 with group overall) that will rank each
person ... but currently it just counts them instead of ranking them.
where the two people with 73 I would like them to have the same rank.

Any thoughts would be appreciated,
_Bigred

 

[Duane Hookom]

I don't think there is an easy way to do this in the report using a running
sum. You can create a new query based on your totals query to use as the
record source. This would be a basic "ranking" query.