Numbering records in a column

[tomr40]

I'm a Driver Ed teacher and I've been using FM for many years to keep track of and schedule my students. However, I'm a novice at FM. Every now and then I do something new to the database and usually it works, but this time I'm stumped. I want a report that has a column of the records numbered consecutively from 1 to n, no matter how many records are selected or how they are sorted. So it would be a page with a list of students (last name, first name) always consecutively numbered starting with 1. I'm assuming the number would have to be a calculation field, but the calculation would change depending on how many records are selected and how they are sorted. 1 Dick

2 Harry

3 Tom

or

1 Tom

2 Harry

3 Dick

or

1 Amy

2 Liz

3 Pam

4 Tammy

Am I correct in assuming that the number neeeds to be a calculation field? If so help me with a formula that would work.

Thanks,

[andygaunt]

Hi,

If you create a calculation field RecordNumber. Calc is Status(CurrentRecordNumber) options is do not store calculated results.

Then you can add this field to your list layout.

No matter the sort order, will always order 1 to x.

HTH

[danjacoby]

Or, in Layout mode, add a "@@" (that's Shift-2, done twice) -- this will automatically number each record shown.

[andygaunt]

Dan,

good call. missed that one.

nice to see they have improved the naming conventions for members. So your an old maid (um hand now!)

[tomr40]

I tried it and,of course, it worked perfectly. Sometimes I am amazed at the things I don't know. Thanks for your expertise.

[tomr40]

Dan,

I tried your method too and it's even simpler than Andy's. I appreciate you both helping me out.

Thanks