Add time to Date Field

[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

 

[Duane Hookom]

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

They are both stored as numbers.