G
Guest
I have a query with the following fields:
dateA, dateB, dateC, dateE, dateF
1/1/05, , 2/1/05, 6/15/05, 12/5/04
, 9-15/05, 6/4/04, , 4/15/05
6/15/05,
In my last query column I'm trying to write an Iif statement in an
expression to return the earliest date of dateA, dateB, dateC, dateE or
dateF. I'm running into trouble where there are dates that are null. How
can I write the Iif statement that will return the earlies date? Thank you
very much.
dateA, dateB, dateC, dateE, dateF
1/1/05, , 2/1/05, 6/15/05, 12/5/04
, 9-15/05, 6/4/04, , 4/15/05
6/15/05,
In my last query column I'm trying to write an Iif statement in an
expression to return the earliest date of dateA, dateB, dateC, dateE or
dateF. I'm running into trouble where there are dates that are null. How
can I write the Iif statement that will return the earlies date? Thank you
very much.