Hello!
I have a query that currently calculates the total number of hours worked by day of week. What I need the query to do is summarize for each month the hours worked between M-F and separately between Saturday and Sunday.
Code:
TRANSFORM Sum(tbl_WorkSummary.[Hours]) AS [Total Hours]
SELECT WeekdayName(Weekday([DateWorked],1)) AS [Day of Week]
FROM tbl_WorkSummary
GROUP BY WeekdayName(Weekday([DateWorked],1))
ORDER BY WeekdayName(Weekday([DateWorked],1))
PIVOT Format(Month([DateWorked]));
Does anyone have a suggestion on what formula I would use to make this work?
Thank you for any help you can provide!