How to Serialize Recs in a table

[access230]

Assume I have a table that has grades 1 to 8 and within each grade the students are sorted alphabetically, Lname / First name.

Is there a technique where, using a query, I can 'serialize' the students and provide a 'student number' in the first grade from 1 to n, start over at 1 for the second grade and end at 'n', third grade 1 to 'n', etc.

This can be done in Excel easily but I hope to stay within Access...using Access 2000. ... if not in 2000 is there a function in 2007?

[RuralGuy]

Perhaps this link will be helpful.

[access230]

I'll give it a shot - thanks!

[RuralGuy]

Post back here if you are still having trouble.