Displaying a line number

[cvandorp]

I think this is a simple problem, but I don't know how to solve it! I am very new to Access but have an extensive Oracle background. I need to create a report that has a record number on each line. For example:

Standings Name Total Points
------------ ------- ---------------
1 Bill 197
2 Bob 173
3 Mary 128
4 Tim 97

The "Standings" column is simply the row of the report. It will quickly identify what place the person is in. It's not stored in the database and in essence, it's equivalent to the "rownum" in Oracle. I am hoping there is a simple thing I can do to get this to work!

Any help is much appreciated!
Caroline

 

[Rich]

Add an unbound textbox, set the control source to =1, set the running sum to overall

 

[cvandorp]

Rich,

Thanks a million! It worked like a charm and I NEVER would have figured that out!!

Your prompt, to-the-point reply is much appreciated!

Caroline