how do i rank on report

  • Thread starter Thread starter _Bigred
  • Start date Start date
B

_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
 
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.
 
Back
Top