[AccessD] combining date columns

Oleg_123 at xuppa.com Oleg_123 at xuppa.com
Thu Mar 11 17:14:01 CST 2004


Dave thanks,
this looks like the best solution; I'll try that tomorrow

> 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
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



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





More information about the AccessD mailing list