Can Access 2000 Time Value Be dispalyed pass 23:59PM

[Guest]

I want to know if anyone know how to get Access 2000 Date/Time property to
display 24:00 hours and more in a text field on a form.

 

[Jeff Boyce]

Brownnate

I may not be understanding your description, but it sounds like you are
trying to use an Access Date/Time field to hold a duration ("24:00 hours and
more").

Date/Time data time is designed to hold "point-in-time" information. As far
as I know, there is NOT an Access data type to hold duration data.

Or have I misunderstood...?

 

[Arvin Meyer]

Actually, you can use a Double to hold the information if you need to
calculate it, but you cannot display it that format without converting it to
text with a custom function. (Then it can no longer be calculated.)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[onedaywhen]

I may not be understanding your description, but it sounds like you are
trying to use an Access Date/Time field to hold a duration ("24:00 hours and
more").

Could be to accommodate a leap second i.e. the 61 second minute <g>?

Jamie.

--