How do I create a date from data in seperate columns

  • Thread starter Thread starter UGAJohn
  • Start date Start date
U

UGAJohn

I have date and time data in seperate columns and I want to combine them into
one datetime field. How do I do this?
 
you can do an update query and update a new field to this:

Cdate([DateField] & " " & [TimeField])
 
I have date and time data in seperate columns and I want to combine them into
one datetime field. How do I do this?
Click to expand...

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