Query Running Sum time by group (1 Viewer)

[jor1111]

I am trying to calculate the running sum of the time difference and group it by date of the equipment used.

sample table:

ID Date In Out
1 15Oct10 10:15 11:05
2 15Oct10 11:45 12:05
3 17Oct10 12:45 13:00
4 19Oct10 2:50 3:00
5 20Oct10 23:05 2:05

Sample query:

ID Date In Out TimeDiff RunningSum
1 15Oct10 10:15 11:05 00:05 00:05
2 15Oct10 11:45 12:05 00:25 00:30
3 17Oct10 12:45 13:00 00:15 00:45
4 19Oct10 2:50 3:00 00:10 00:55
5 20Oct10 23:05 2:05 3:00 3:55

I calculated the TimeDiff in query using expression TimeDiff: Format([IN]-1-[out],"Short Time"). Can anyone help how to get the Running Sum?

Thank you in advance......

 

[avacess]

jor1111,

did you manage to create the running sum for the time? i have the same problem. i would appreciate if you could give me a hint.

avacess