count records

[sadie]

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

 

[Pat Hartman]

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

 

[sadie]

Thanks so much, it worked

 

[Muzicmn]

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

 

[Rich]

Change the running sum to OverGroup

 

[Muzicmn]

will give it a shot thanks