Concant a date field and a time field

  • Thread starter Thread starter paul
  • Start date Start date
P

paul

I have a date field in a table called tblStatus. The
field only retains the date, nothing else. There is
another field that has the time as 12.68 or 15.83 or 2.04
I would like to concantenate the two fields into one
Date/Time field for future calculations. The date field
is called date and the time field is called time. I know
what you're thinking but I did not create it. Any help
would be appreciated. Thanks.
 
I have a date field in a table called tblStatus. The
field only retains the date, nothing else. There is
another field that has the time as 12.68 or 15.83 or 2.04
I would like to concantenate the two fields into one
Date/Time field for future calculations. The date field
is called date and the time field is called time. I know
what you're thinking but I did not create it. Any help
would be appreciated. Thanks.
Click to expand...

An Access Date/Time field of course supports both, and whoever created
this "time" field deserves a flogging with a wet noodle. <g>

What time is 15.83? 3:50? Is it hours and fractions or what? If so,
you can multiply by 60 to get minutes and use DateAdd:

DateAdd("n", [datefield], 60*[timefield])
 
Back
Top