Add time to Date Field

  • Thread starter Thread starter Rita Brasher
  • Start date Start date
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
 
Add them in a query with an expression like:
DateAndTime: [DateField]+[TimeField]

They are both stored as numbers.
 
Back
Top