running sum

J

J A Friend

I am trying to create a report that has an available balance(budget) payroll dollars for the month grouped by the week, then by the day. Is it possible to create a query that will give me a running sum of hours so i may calculate total pay including overtime rate by day. For example during a week an employee works monday - wednesday at reg pay rate, but sometime on thursday the have worked more than 40 and have a total of 54 hours for the week. I wish to calculate payroll hours for all employees each day. can this be done?
 

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

Top