B
Bill
Hi,
I would need your help to set the query for searching the latest date of any
five dates.
example:
Field1 Field2
***** ******
Date1 - 03/02/2004
Date2 - 02/02/2003
Date3 - 04/07/2002
Date4 - 05/06/2002
Date5 - 06/09/2004
I would like to create two new columns to give me the latest Date and Date#.
from any of Date1 to Date5.
Field3 Field4
***** ******
Date5 06/09/2004
Your help would be much appreciated.
Thanks
I would need your help to set the query for searching the latest date of any
five dates.
example:
Field1 Field2
***** ******
Date1 - 03/02/2004
Date2 - 02/02/2003
Date3 - 04/07/2002
Date4 - 05/06/2002
Date5 - 06/09/2004
I would like to create two new columns to give me the latest Date and Date#.
from any of Date1 to Date5.
Field3 Field4
***** ******
Date5 06/09/2004
Your help would be much appreciated.
Thanks