Ralph and Brian,
Thank you very much for the informative replies. Ralph, I had looked at
the material in your book, but did not seem to cover my problem (this is
most probably because I cannot define my problem adequately).
Perhaps I can define my problem again?
The panel which records the following information:
date, action carried out for a client, comments, time (plus a few other
entries not of relevance here).
Each time entry will always be less than 24 hours. The only difficulty I
am having is in the report when (in the final footer section of the sub
report mentioned in my previous post) I add the time field and from the
available options I choose sum. It is here that I am having the problem.
The method in the book ("Calculating Elapsed Time Across the 24-Hour
Barrier") I think involves adding extra fields some which converts the
time field to a decimal. If this is what is required then I can use that
decimal field from the panel in the report to create the sum without
problem.
I would be grateful for confirmation that I have not misundestood what I
have been told.
Victor Warner
On Wed, 12 Apr 2006 15:40:28 +0100, Ralph Alvy <[EMAIL PROTECTED]> wrote:
On Wed April 12 2006 3:42 am, Victor Warner wrote:
I am having difficulty in totalling a group of times which exceed 24
hours.
Take a look at the section in my book called "Calculating Elapsed Time
Across
the 24-Hour Barrier". It talks about the using what I coined the Moment
Function, which is what Brian is using here. The examples in that book
should
help you.
_______________________________________________
Dataperf mailing list
[EMAIL PROTECTED]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
_______________________________________________
Dataperf mailing list
[EMAIL PROTECTED]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
