[AccessD] combining date columns

Mcgillivray, Donald [ITS] donald.a.Mcgillivray at mail.sprint.com
Thu Mar 11 16:46:52 CST 2004


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



More information about the AccessD mailing list