Overtime Report/Query Help

[ajhts]

I have a report that I generated that will list each day and the day of the week. I have a footer for week showing up at the end of the week and tells me the number of overtime hours. Works Perfect!

Now, I need help! Our payroll works in a different way. We are paid for the 1st through the 15th, and the 16th through the 31st. If the 1st falls on, lets say, a Wednesday. How do I get it to continue to show me the 1st through the 15th, but also let me know if that week with the 1st in it accumulated overtime hours without actually showing me Sunday through Tuesday. I hope that I am explaining it right! Thanks,

AJ

 

[dhookom]

Since no one has answered this question, perhaps you should add some records that illustrate your issue. Make sure you include how you would calculate the OT based on your sample records. Add enough records to fully specify your situation.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]