Ranking on a report

[pat67]

Hello, how do show a numbered rank on a report?


Say my report says

Name Number
Joe 100
Bob 85
Frank 75
Bill 62
Steve 58

how do I show it like this?

Name Number
1 Joe 100
2 Bob 85
3 Frank 75
4 Bill 62
5 Steve 58

 

[Duane Hookom]

You can add a text box in the detail section:

Control Source: =1
Running Sum: Over All

Your issue might be if you have duplicate numbers.

 

[pat67]

You can add a text box in the detail section:

Control Source: =1
Running Sum: Over All

Your issue might be if you have duplicate numbers.

--
Duane Hookom
Microsoft Access MVP









- Show quoted text -

that works. thanks

 

[June7]

Check out this link:
http://www.lebans.com/rownumber.htm