I have a query running on a table that has the date, the employee and how many hours they've worked. What I need to do is sum the hours up by week so that I can multiply regular hours by their regular rate and their overtime hours by their OT rate.
I know I need to group by dates by week with a DatePart function or something similar and then Sum on the hours worked. Is it possible to group an employee's hours together only by week? And then have it group the next week's hours together, etc. etc. for each employee?