[AccessD] combining date columns

I didn't notice that one at all. Just goes to show how much we see 
what we expect to see  :-(

On 11 Mar 2004 at 16:46, Mcgillivray, Donald [ITS] wrote:

> Try changing the "and" to "&":
> 
> [Column1] & [column2] & [column3] as Combined  instead of
> 
> [Column1] & [column2] and [column3] as Combined 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
> McLachlan
> Sent: Thursday, March 11, 2004 2:25 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] combining date columns
> 
> 
> On 11 Mar 2004 at 16:10, Oleg_123 at xuppa.com wrote:
> 
> > 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 ?
> > 
> Try Datevalue([Column1] & [column2] and [column3])
> 
>  
> -- 
> Lexacorp Ltd
> http://www.lexacorp.com.pg
> Information Technology Consultancy, Software Development,System 
> Support.
> 
> 
> 
> -- 
> _______________________________________________
> 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

 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.