Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- mobmad
- Thread
- Replies: 1
- Forum: Microsoft: Access Tables and Relationships
-
Format for hrs:mins input
Paul Many many thanks indeed. Works an absolute treat. [2thumbsup] You're a star. Thanks again. MOB- mobmad
- Post #15
- Forum: Microsoft: Access Tables and Relationships
-
Format for hrs:mins input
Paul thanks a lot for this - part solved a BIG problem for me creating time sheets in Access from external data. =Int(Sum([TimeField]))*24+DatePart("h",Sum([TimeField])) & ":" & DatePart("n",Sum([TimeField])) However when the minutes calc comes to single digit...- mobmad
- Post #13
- Forum: Microsoft: Access Tables and Relationships
