Numbering records in a Report

I use VB6 and report designer my records are like this

John 35000
Mary 27000
Tom 12000

I d like to get a report like this

1. John 35000
2. Mary 27000
3. Tom 12000

Can anyone out there help me?
Thanks in advance
Yannis

test

?

:o

Just a thought but have you considered creating a temp table on the fly with an extra "counter" field appended to the beginning and then spinning through the records in the original recordset and inserting them into the new recordset counting all the while? Then you can use the second recordset as your source for the datareport

Hope this helps :D

I ll do it if no other option is available. Thanks for the help!
Yannis