Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Apr 2004
    Location
    Sydney, New South Wales, Australia
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Time Format - Fractions of Seconds (2002 SP3)

    I want to format a Date/Time field for an Athletics Database that will allow 100th of seconds to be entered.

    An example is - 1:35.94 = 1 Minute 35 Seconds 94/100th of a second

    Excel is able to do this easily by using "mm:ss.00", but this same format is not acceptable to Access.

    Can someone let me know how I am able to achieve this in Access?

    Thank you

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Time Format - Fractions of Seconds (2002 SP3)

    Welcome to Woody's Lounge. The Date/Time data type in Access doesn't readily support fractions of seconds. If you want to work with fractions of seconds, you must store them some other way. See newsgroup thread for some ideas.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •