Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Time with correct values but wrong format (Access 2000)

    Hi

    Now I am sure this has been covered before but I have tried searching and haven't found the answer.

    I have Access set up to linked tables via ODBC - one of the fileds holds time value that I require, however it holds it as a number but it isn't the decimalisation of the time i.e. it holds the right value of hours and minutes but Access doesn't see it as time value.

    Entries are like this:

    0
    11.3
    9.45
    9.15
    11.3
    11.3
    9.15
    11.3
    9.15
    9.15
    8

    standing for 11 hours 30 mins , 9 hours 15 mins, 8 hours zero minutes etc.

    Any idea how to get Access seeing it as a time value without changing the values?

    Any help would be appreciated and apologies if this is soooo simple that you wonder if I know how to use a mouse <img src=/S/bash.gif border=0 alt=bash width=35 height=39>

    MOB

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

    Re: Time with correct values but wrong format (Access 2000)

    You can create a query based on the linked table, and create a calculated field that converts the numeric value to a time value:

    <code>TheTime: TimeSerial([TimeNumber]1,([TimeNumber]*100) Mod 100,0)</code>

    where TimeNumber is the name of the number field holding a time, and TheTime is the column heading you want to display.

Posting Permissions

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