running sum for hour and minute

I

inungh

I have a query for working hour and minute and would like have a
running sum like following:


Employee (Working hour) (Working Minute) (Working hour Required)
(hour run sum) (minute run sum)
Employee1 40
10 35
5 10
Employee1 26
30 35
-4 20
Employee1 37
0 35
-2 20


Is it possible to have a query for running sum for 2 fields to
consider borrow and carry for hour and minutes?


Your information is great appreciated,
 
S

strive4peace

please do not ask the same question in 2 different newsgroups. this
question has been asked here:

microsoft.public.access.reports

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
:) have an awesome day :)
*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

running sum for working hour and minute 4
Time Calculated minus breaks & lunch 2
Time total 2
SQL JOIN simplifying 5
How do I sum a daily hour total by week? 3
Running Sum 3
Counting unique values with criteria 10
Error - CANNOT HAVE AGGREGATE FUNCTION IN EXPRESSION 4

Top