Web Development
by monshines Accepted solution
by tony hopkinson Accepted solution
Best bet is number of seconds.
Select DateAdd(second,[MyNumber] * 60, 0)
That will give you number of seconds since the base date in access.
Then format it as mm:ss for output. Generally I store durations as number of seconds or milliseconds, otherwise you have to do a lot of arsing about to use it.
by tony hopkinson Accepted solution
Post your actual query mate we'll have a furkle.
Maybe we need to do a bit of converting, waht datatype is your equivalent of MyNumber?
This discussion is closed to new replies.
Sort by Trending