[AccessD] combining date columns

Oleg_123 at xuppa.com Oleg_123 at xuppa.com
Thu Mar 11 15:10:52 CST 2004


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





More information about the AccessD mailing list