user defined time format

A

Allan Jackson

Hi all,
I need to be able to record time in a field and the format is minutes
seconds and fractions of seconds, eg 1:20:223
Is there anyway that "access" can record, compare and report on this type of
data in this format?
I have noticed that I can define minutes and seconds but not fractions of
seconds. Additionally when I use the hh:nn:ss format "access" will place am
or pm after it. Is there a way to remove this?
Many thanks if you can assist
Regards
Allan
 
A

Allen Browne

No. The date/time field in JET cannot handle fractions of a second. Neither
can the date/time functions in VBA.

You will need to create your own data type, and functions for this kind of
data.
 

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

How can I store time values in access 2
Calculating Time Difference 2
elapsed time calculation help needed 1
How to return a 12 hour time format without the AM in an Access query 2
Time format in a statement 8
Times 2
Adding timer to text box 1
Problem w/Date time function 2

Top