Dave Sharpe
davesharpe2 at cox.net
Thu Mar 11 16:57:45 CST 2004
Oleg What do You expect to be the result to be? 1/1/2002 & 12/31/2003 & 2/22/2004 as a date ? 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