adding total time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query where all services are captured; I would like to be able to
have the total time calculated.

The field I want to add up is "total time." Im stuck and what Ive been
getting is the total time per line or record which is the same. Im looking to
add the entire field up.
Thanks for your help,
Mark
 
I have a query where all services are captured; I would like to be able to
have the total time calculated.

The field I want to add up is "total time." Im stuck and what Ive been
getting is the total time per line or record which is the same. Im looking to
add the entire field up.
Thanks for your help,
Mark
Click to expand...

Please post the SQL of your query, and if necessary some description of your
table structure. We can't see it from here!

Note that Date/Time fields are best for storing specific points in time, and
have some real problems when it comes to storing durations. In particular,
adding a set of time values which exceed 24 hours will end up creating a date
value on (or after) December 31, 1899 - the zero point of Date/Time values is
midnight, December 30, 1899, so 26 hours and 30 minutes is actually
#12/31/1899 02:30:00#. Consider storing durations as Long Integer numbers,
counts of the finest desired granularity of time (seconds, minutes, hours,
days...). If you're storing minutes and want to display in an hh:nn format,
use an expression like

[duration] \ 60 & Format([Duration] MOD 60, "\:00")


John W. Vinson [MVP]
 
Back
Top