Prev: I cannot view my e-mail
Next: Flexgrid in Access?
From: Max on 24 Feb 2005 16:15
t = TimeSerial( Int( v / 100 ), v - 100 * ( Int( v / 100 ) ), 0 )

Where where I put this in my query or in the report.

"James Hahn" wrote:

> Divide the value into hours and minutes, and use the TimeSerial function to
> convert these values to a time
> t = TimeSerial( Int( v / 100 ), v - 100 * ( Int( v / 100 ) ), 0 )
> --
> "Max" <Max(a)discussions.microsoft.com> wrote in message
> news:81B3D6E1-5D6B-4F72-9895-F90C22335E79(a)microsoft.com...
> > How can I change the time from millitary time (0900) to 9 or (0925) to
> > 9.25.
> > Each one of these are in one feild.
>
>
>
From: James Hahn on 24 Feb 2005 16:35
If you aren't actually going to use it as a variable (for instance, for
doing some sort of comparison) then it's simplest just to insert it into the
report.
--
"Max" <Max(a)discussions.microsoft.com> wrote in message
news:1976EC6D-B973-4707-80C0-D43A51B4F6BB(a)microsoft.com...
>t = TimeSerial( Int( v / 100 ), v - 100 * ( Int( v / 100 ) ), 0 )
>
> Where where I put this in my query or in the report.


First  |  Prev  | 
Pages: 1 2
Prev: I cannot view my e-mail
Next: Flexgrid in Access?