Prev: 2000 application didn't convert to 2007 well
Next: Diseño de la Tabla
From: UGAJohn on 21 Jan 2010 11:16
I have date and time data in seperate columns and I want to combine them into
one datetime field. How do I do this?


From: ghetto_banjo on 21 Jan 2010 11:48
you can do an update query and update a new field to this:

Cdate([DateField] & " " & [TimeField])

From: fredg on 21 Jan 2010 11:53
On Thu, 21 Jan 2010 08:16:02 -0800, UGAJohn wrote:

> I have date and time data in seperate columns and I want to combine them into
> one datetime field. How do I do this?

These fields are Date/Time datatypes?
Just add them together:
=[DateField] + [TimeField]
#1/5/2010# + #4:55 PM# = #1/5/2010 4:55 PM#

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
 | 
Pages: 1
Prev: 2000 application didn't convert to 2007 well
Next: Diseño de la Tabla