Add time to Date Field

R

Rita Brasher

In my table, I have a date column and I also have a time column. I need
to join these into one date-time field so that I can do some time
comparisons. How can I join these two into one column?

Any help is appreciated!
Rita Brasher
FedEx Express
 
D

Duane Hookom

Add them in a query with an expression like:
DateAndTime: [DateField]+[TimeField]

They are both stored as numbers.
 

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

Similar Threads

Query using only criteria for one column when 2 are limited 3
Convert Text to Date 4
Computed Column from Date Field 1
Error upon exporting results of query to text file 1
Date comparison between 2 datetime fields 1
Append Query, New Column help 1
Date and Time 1
Text to Date Format 1

Top