Access 2007 SP 3, Windows XP Version 2002 SP3
I have a calculated field ([SendDate]) in a query that calculates a specific date by adding 10 days to it ([DOD]+10). The report based on this query is grouped by month by week on SendDate: Format$([SendDate], "mmm", 0,0)
The report is then sorted by [SendDate], then by [DOD], and last by [Pt].
On the printed report each week is separated nicely. However, I'd like for it to show Saturday as the first day of the grouping (instead of the last day of the grouping). How do I accomplish this without too much code? Isn't there a simple way of doing this on the "Design View" layout of the form?
Thanks so much!