fraction of a second

[Angus]

can anyone tell me how to get a format to show seconds to 1 decimal place?
I can get a format in excel to show hh:mm:ss.0 but I cannot seem to get it
in access. Any help would be greatly appreciated

Thanks
Angus

[Rick Brandt]

Re: fraction of a second

"Angus" <anguswaugh@one tel.net.uk> wrote in message
news:3fabb02b@2 12.67.96.135...[color=blue]
> can anyone tell me how to get a format to show seconds to 1 decimal[/color]
place?[color=blue]
> I can get a format in excel to show hh:mm:ss.0 but I cannot seem to get[/color]
it[color=blue]
> in access. Any help would be greatly appreciated[/color]

Access (Jet) only resolves DateTime to a resolution of one second. You
would have to store finer precision than that in a text field and work out
a way to do the math against them yourself.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Peter De Baets]

Re: fraction of a second

Angus,

We've developed a set of functions that can be used to manipulate time
values below the level of a second. The free module is available here:

http://www.peterssoftware.com/ctf.zip

Hope this helps,


--
Peter De Baets
Peter's Software - MS Access Tools for Developers

http://www.peterssoftware.com

"Angus" <anguswaugh@one tel.net.uk> wrote in message
news:3fabb02b@2 12.67.96.135...[color=blue]
> can anyone tell me how to get a format to show seconds to 1 decimal place?
> I can get a format in excel to show hh:mm:ss.0 but I cannot seem to get it
> in access. Any help would be greatly appreciated
>
> Thanks
> Angus
>
>[/color]