How do I create a date from data in seperate columns

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?
 
G

ghetto_banjo

you can do an update query and update a new field to this:

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

fredg

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#
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top