Make a total of hours work in one day and end of week total

C

CarlieCumner

I'm trying to make a report that i can use to calculate our weekly wages, so
far ther report is draging info from a table where we enter our employees job
dockets. However we might have two dockets for the same employee for the same
day. I've tried using a Running Sum, which will give me the total hours for
the day, but as overtime rates come into affect for anything over 7 hours
worked in one day, I need to be able to take the end result of the Running
Sum for a particular and take 7 from it to be left with the hors of over
time. Am I able to use code for this and get rid of the Running Sum
altogether, if so what will the code be like, I've only written code to open
and close forms/reports etc. Please Help???
 
D

Duane Hookom

How about providing some sample records with the desired display in your
report. Your description lacks specifics and is a bit difficult to
understand. I'm not sure why you think you need to use Running Sum.
 

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

Work Budget Salary vs Real Time Salary 0
Dumb question alert! What program to use? 0
Calculating total hours 2
How do I get a total work hours by a week phases 0
Total not correct in Footer 2
allocate resource over long period of time 0
Total in Access Reports 6
Total is off by a couple of cents 4

Top