ibookuser2 Posted December 17, 2001 Share Posted December 17, 2001 OK, one more question from me today. In a job database I have a list of jobs with different priorities and dates. I want to write a script to sort the jobs by priority, then by date, and then by time. I can get that far just fine. I'd then like the script to go down the list and assign a field in each record a numerical value representing that job's location in the queue. Any suggestions? Link to comment Share on other sites More sharing options...
The Bridge Posted December 17, 2001 Share Posted December 17, 2001 I think the function you're looking for is Status(CurrentRecordNumber), which will change according to a record's position within a found set and sort order. Link to comment Share on other sites More sharing options...
per Posted December 22, 2001 Share Posted December 22, 2001 Hi there, My suggestion: Make a new field named "Number" After your first step sorting the items in right order: Go to first Go to field Number Replace with serial numbers, Custom values, Initial value 1, Increment by 1 and perform without dialog. Im not sure if you should mark "Entry serial numbers in Entry Options" but try with and without. I use this and its work good. Good luck. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8160 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