Newbies dpagan Posted April 25, 2010 Newbies Share Posted April 25, 2010 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. Link to comment Share on other sites More sharing options...
David Jondreau Posted April 25, 2010 Share Posted April 25, 2010 Make an unstored calculation and set it to = Get(recordNumber) Link to comment Share on other sites More sharing options...
comment Posted April 25, 2010 Share Posted April 25, 2010 Or type @@ in the body part of the layout. Link to comment Share on other sites More sharing options...
Newbies dpagan Posted April 25, 2010 Author Newbies Share Posted April 25, 2010 Perfect....knew it had to be easy. Much appreciated. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5138 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now