Need help getting sum from time card table

[dakcg]

Greetings,

In my database, I track when someone logs in and logs out. I found the code that can bring the time out of the date field (GetElaspedTime), and the time shows on the report in hours, minutes & seconds, but how do you get the Total time? The regular Sum code doesn't work.

Any help would be greatly appreciated!!

DAK

 

[Jack Cowley]

The article that you got the Elapsed Time code from also shows you how to total time. Here is the article...

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q88657

 

[dakcg]

Do you mean the part with the GetTimeCardTotal? The way I read it, that works with info in a table and not on a report? Will that code work with the info on the report, or do I have to use a table to get the first in order to use the total part?
Thanks for the any info.
DAK