Using hours in weekly schedule format 40:00:00 and reporting in Cr

[Denise]

I am creating a database with weekly staff hours in a format of 40:00:00, I
figured out how to get access to accept these numbers but now I need to
transfer this data accross to a crystal report to help compile it all. I
believe their may be a setting in Access to allow this data to transfer in
the format I want. Any ideas? I may have to format Crystal reporting but
was hoping to do all of it in Access that I can.

 

[Douglas J. Steele]

You can't, at least not as a Date field. The Date field in Access is a
specific point-in-time, not a duration (under the covers, it's an 8 byte
floating point number where the integer portion represents the date as the
number of days relative to 30 Dec, 1899, and the decimal portion represents
the time as a fraction of a day).

You could read it in as a text field and then parse it into a numeric field
that holds the number of hours. You definitely should not be using a time
field to store the durations.

 

[Denise]

Doug, Thank you. I'm actually using a number field and have adjusted the
format it is accepting the numbers as 40:00:00 HH:MM:SS. My main problem is
getting it to Crystal reporting in that exact format still. I'm not sure
Access can do it or if I need to make Crystal somehow keep my format. Thank
you for the input

 

[Douglas J. Steele]

I've never had a need to use Crystal Reports from Access, as I find Access's
reporting capabilities superior.

Sorry I can't offer any suggestions.