Sub-grouping in Reports

G

Guest

I need to group employee hours by workweek (Sunday - Saturday) within
individual timesheets for a pay period based on dates.
So, the most recent pay period was 10/25 - 11/09, which starts on a Thrusday
and ends on a Thursday.
The weekday is indicated on the report via an expression. How can I group
the workweek within the calander worksheet?
 
M

Marshall Barton

dptroutt said:
I need to group employee hours by workweek (Sunday - Saturday) within
individual timesheets for a pay period based on dates.
So, the most recent pay period was 10/25 - 11/09, which starts on a Thrusday
and ends on a Thursday.
The weekday is indicated on the report via an expression. How can I group
the workweek within the calander worksheet?


Try grouping on the start of week date using an expression
like:
DateAdd("d", 1-Weekday(dt,5), dt)
where dt represents your date field.
 

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