gjones
Posts: 1
|
| Posted: 02/13/2006, 1:34 AM |
|
I have a tasks database and want to list the entries by a clacuated priority. I have the code to calculate the priority which is based on two fields Importnace and Urgency.
The urgency field has options such as this week, 1 week, 2 weeks, by end of term, by end of year etc. My code scores the urgency based on when the task was recorded - end of the term has a lower score than this week. However if the task has not been completed the code increases the score as the deadline approaches.
So far so good. What I want to do now is display the tasks in descending order of priority score.
Can anyone help with this?
|
 |
 |
|
