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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Denise - 23 Jan 2008 02:11 GMT

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.

Reply to this Message

Larry Daugherty - 23 Jan 2008 06:25 GMT

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

Signature

-Larry-
--

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

Reply to this Message

Jamie Collins - 23 Jan 2008 08:52 GMT

On Jan 23, 6:25 am, "Larry Daugherty"
<Larry.NoSpam.Daughe...@verizon.net> wrote:

> > I am creating a database with weekly staff hours in a format of
> 40:00:00, I
[quoted text clipped - 5 lines]
> transfer in
> > the format I want. Any ideas?

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.

--

Reply to this Message