Position of calculations after sorting

[dpagan]

This has to be easy.

database is in list format. I have an auto enter field set up. I need it to auto enter the numerical position of a record based on sorting criteria.

It would list numbers 1-however many records are entered.

example....if i have 3 fields Name, Age, Number of Kids.

George-34-2, Bill-29-0, Nancy-55-6

If I sorted by age, the field would show a "1" by Bill

If I sorted by No of Kids, the field would show a "1" by George.

since the sorted value would be first.

Any help is appreciated.

[David Jondreau]

Make an unstored calculation and set it to =

Get(recordNumber)

[comment]

Or type @@ in the body part of the layout.

[dpagan]

Perfect....knew it had to be easy. Much appreciated.