Results 1 to 2 of 2
2004-06-28, 10:52 #1
- Join Date
- Dec 2003
- Thanked 0 Times in 0 Posts
Time with correct values but wrong format (Access 2000)
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:
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>
2004-06-28, 11:06 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 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.