I have a query with 5 fields, each contain a different date. Some are filled in, some are not. (five step process, everytime a step is complete a date is filled in). I want another field to tell me what date is the most current. I tried doing it with a huge IIf statement, but it was way too big. Is there an easy way to do what I need to do?
Example:
Entry 1 - 1/23 2/10 2/12 xx xx
Entry 2 - 4/23 xx xx xx xx
Entry 3 - 1/11 1/31 2/13 2/27 3/1
entry 1 most current is 2/12
entry 2 most current is 4/23
entry 3 most current is 3/1
It should always work that dates will be sucessive, so is there a way to compare the null date entries and use that to find the newest?
Thanks
Garrett.
Example:
Entry 1 - 1/23 2/10 2/12 xx xx
Entry 2 - 4/23 xx xx xx xx
Entry 3 - 1/11 1/31 2/13 2/27 3/1
entry 1 most current is 2/12
entry 2 most current is 4/23
entry 3 most current is 3/1
It should always work that dates will be sucessive, so is there a way to compare the null date entries and use that to find the newest?
Thanks
Garrett.
