[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.