[AccessD] combining date columns

Oleg

I'd suggest selecting it not trying to combine.

theDate = iif(Column1 is not null, Column1, iif(Column2 is not null,
Column2,  Column3 ) )

Dave

----- Original Message ----- 
From: <Oleg_123 at xuppa.com>
To: <accessd at databaseadvisors.com>
Sent: Thursday, March 11, 2004 4:10 PM
Subject: [AccessD] combining date columns


Group,
I need to combain 3 date fields into one (where the date apears either in
first column or in second or in third),
I tried [Column1] & [column2] and [column3] as Combined (obviously with
diff names) i am coming up with a field that is not treated like date.
(numeric field prob)
Format([Column1] & [column2] and [column3]),"mm/dd/yyyy" as Combined

also didn't work. Any suggestions ?


-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com