group by week

[Guest]

I would like to produce a report that will group by the Invoice Ref. and show
a weekly summary of all buying. I have a Invoice Date column which specifies
the date of when the invoice was created. From this I want to be able to
group the 5 working days (Mon-Fri) and show the total for that week. Ideally
I want a summary of all 4 weeks on 1 Report (which would show a month of
buying broken down into weeks).

 

[Arvin Meyer [MVP]]

Open the Sorting and Grouping dialog in your report's design view and add a
group header for the datefield. In the Group On property, set the dropdown
to Week, and set the Interval property to 1 (the default).