Time data type

  • Thread starter Thread starter Jo
  • Start date Start date
J

Jo

I am using an Access database to import data from a csv file. There
is a dution field measured in hours:minutes:seconds but the hours
exceed 23 which is not accepted in the long time data type. I have
looked in custom time fields but h only lets in numbers 1-23. Is
there any way around this?

I need hh:mm:ss, but allowing any number of hours eg 45:11:23

Any help would be greatly appreciated

Jo
 
The time data field is for Time, which is constrained to the values
12:00:00am to 12:59:59pm.

The duration of time is not a time, it is a number. Whether you store it's
value in milliseconds, seconds, minutes, or decades, it is a finite number.
So, I would recommend that you change the datatype to some type of number.
Long Integer, Integer, Single, Double.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top