Numbering entries in a report

[ArcherSteve]

I have a report that prints out the results of an archery tournament with several divisions. Is there anyway to number these results? i.e.
1 Archer1
2 Archer2
3 Archer3

Basically, I need an autonumber field or something similar to be in the Detail section of the report.

Thanks,
Steve

 

[Pat Hartman]

Add a new control to the report.
Set its ControlSource to =1
Set its RunningSum property to Over Group or Over All depending on how you want it to count.

 

[ArcherSteve]

Pat,
You are a genius. Thanks for the help.

Steve

 

[gfcaim]

...and in a form?

How do i do the same thing in a continuous form?

 

[Pat Hartman]

That's a horse of a different color. The technique is simple in a report because the report is produced sequentially. You can scroll back and forth but the recordset isn't "live" and so won't change. In a form the recordset is "live" so when you scroll back it is possible to see a record that wasn't there before.

I would recommend not doing this unless your recordset is very small. Search the archives. I believe that Jon K posted a sample db that worked well for small recordsets.