I want to give each record a number in a report so I can easily identify the student...ex..I have a waitlist for services and I want to know which number each on eis without doing a manual count as I have over 100 on the list

Add a control with a recordSource of =1
Set the control's runningSum property to Overall

Thanks so much, it worked

I have a similar problem and the suggestion works great, but my problem is a little more intense...

I have a db for an elementary school, i created a query that will print out a "teachers list" of all the students.... the report is sorted and grouped by teacher so i can have a different teachers roster on a separete page.

the code given works great it numbers the students just like i need but it continues on, for example if teacher 1 has 15 students, than the 15 are numbered correctly, but when i go to page two the students start at # 16... is there a way to start this code all over again per page?

thanks

Change the running sum to OverGroup

will give it a shot thanks