Re: Convert seconds to m:ss.th

Tim,

Thanks for following up. I am trying to use the function in a query.
Below are the two fields I have. Fin_Time is being pulled from another
database and I am trying to convert it  in field Time to m:ss.th before
putting it through to a DataPage. You can see that any number with
tenths and hundredths over .5 moves the seconds up one. I am just not
sure where to do something differently.

Fin_Time	Time
256.30	04:16.30
259.54	04:20.54
264.36	04:24.36
269.60	04:30.60
274.70	04:35.70
277.85	04:38.85
279.32	04:39.32
290.72	04:51.72

Thanks for any help,
Brad

.

Relevant Pages

  • Re: Delete Table
    ... Thanks Tim, if you refer to further up this posting I have already tried ... The form opens but does not display anything until the query has ... In an ODBCDirect workspace, if you include the optional dbRunAsync ... > DoCmd.Close acForm, "frmPleaseWait" ...
    (microsoft.public.access.modulesdaovba)
  • Re: Total Box
    ... I do have lots of differing tables - I think I'm going to start ... and include Product.Amount in the query. ... > If you do have different tables for processors, memory, and other types, ... > "Tim Gordon" wrote in message ...
    (microsoft.public.access.forms)
  • Re: Unbound field in query
    ... Tim ... "Jeff Boyce" wrote: ... >> I am trying to run a query to show certain records on a form. ... the user would select which records to exclude from the report. ...
    (microsoft.public.access.queries)
  • Re: Shelve operations are very slow and create huge files
    ... > Hello Tim, ... > seconds with shelve. ... > With cPickle, ... functions for caching query results using gzipped cPickles. ...
    (comp.lang.python)
  • Re: Delete Table
    ... Thanks Tim, I will look at this and see if I can make it work, not sure what ... it means by in an ODBC workspace. ... the append query is based on several other queries ... StillExecuting property on the object from which the Execute method was ...
    (microsoft.public.access.modulesdaovba)