R
Ron
My Access database contains several date fields that
indicate due dates for various tasks. I want to build a
query that will tell me for each record what the next due
date is. For example, if I have three date fields, Task1,
Task2, and Task3, and the values in my fields for record 1 are:
Task1: 9/1/04
Task2: 8/25/04
Task3: 9/15/04
and todays date is 8/13/04, I want an expression in my
query that will give me 8/25/04, which is the next date in
my series of fields.
I did this once before in Excel using, among other things,
the Rank function. Access doesn't seem to have anything
equavent to Rank.
Can anyone suggest a solution?
Thanks,
Ron
indicate due dates for various tasks. I want to build a
query that will tell me for each record what the next due
date is. For example, if I have three date fields, Task1,
Task2, and Task3, and the values in my fields for record 1 are:
Task1: 9/1/04
Task2: 8/25/04
Task3: 9/15/04
and todays date is 8/13/04, I want an expression in my
query that will give me 8/25/04, which is the next date in
my series of fields.
I did this once before in Excel using, among other things,
the Rank function. Access doesn't seem to have anything
equavent to Rank.
Can anyone suggest a solution?
Thanks,
Ron