Summary by week starting Monday

[begin2know]

I want a chart that summarizes labor totals by week (no problem so far), but starting on Monday, not Sunday.

When I group on Work_Date for each week, Crystal assumes the week starts with Sunday. How do I get weeks grouped Monday thru Sunday?

CR 10
Access 2000

 

[synapsevampire]

Try a formula containing:

datepart("ww",{table.date},crMonday)

-k