running sum for hour and minute

  • Thread starter Thread starter inungh
  • Start date Start date
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,
 
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 :)
*
 
Back
Top