[AccessD] combining date columns

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



More information about the AccessD mailing list