Total Time box

[imintrouble]

Hello! I have created a report which returns the information I need, how i want it. However my question is this:



Because I have a field called Hours Worked, it records the time in the format "# hours, # minutes, # seconds", with the # being the actual numbers. I need one text box located just below this field stating the total time recorded so far. so this would mean adding the time like this:

4 Hours, 3 Minutes, 27 Seconds
6 Hours, 57 Minutes, 33 Seconds


Total Hours: 11 Hours

of course if the time doesn't line up to a perfect amount of hours, thats ok, i was just being creative.

[TheShabz]

I'm not all that great with Access reports, but try the DSum() function.

[imintrouble]

from what i've seen of DSum(), it would work fine up until the last point of the criteria which must be met. Because my information is in number then string ( 4 Hours ) form, I'm not sure how to create any criteria of how to make this work.

[pbaldy]

You are in trouble.

That is not a good way to store the time; I'd have one numerical field representing the number of seconds, and the rest can be derived from that (10,000 seconds is x hours, y minutes and z seconds).

To keep it in the format you have it, I suspect you're going to have to create a function to parse out the values, get them to a common denominator, add them up, then parse them back out to the desired format. It won't be simple.