Transferring cumulative weekly time 40:00:00 from Access to Crysta

[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.

 

[Larry Daugherty]

Since this newsgroup is about helping Access developers with their
*Access* issues you might find better help in a newsgroup devoted to
"Crystal Reports". Access does not have the burden of knowing what
"crystal" or any other application needs.

If *you* can get an unambiguous definition of the textual data that
would have to reside in foreign source for "crystal" to use it then
post back with that.

My guess would be that you could deposit the data in a text field that
has any format you want. Any Report utility should be able to present
the content of a text field exactly as it was found.

HTH

 

[Jamie Collins]

I think the issue here is that you are using a column of type DATETIME
for to store/calculate/sum intervals. Also, I think you are confusing
'data' and 'formatting'.

Consider changing your design to use a numeric type e.g. a column of
type INTEGER for the number of seconds. Then you can *format* the
numeric value as appropriate and _do so in the front end in question_.
For example, in Crystal, you can use a formula to convert numeric
seconds into 'yy:mm:ss' format (hint: divide seconds by 60 to get the
number of minutes etc).

Jamie.

--