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?