generating an serial number field in data report

Hello,
I am using data report in vb 6.0 and I have to show the extracted records with serail no. auto-incremented. I cannot use the ID from the database since it is an auto-number and if a record is deleted, the records loose their continuity.

Plz Help!!!!
Thanks in advance!!!!!!!

Have you tried using the Special Field called Record Number? I've never used it but it will probably do the trick. Otherwise, you can create your own formula that increments a shared variable from a specific starting number.