MS Access

  • Thread starter Thread starter Dasa
  • Start date Start date
D

Dasa

I have report in MS Access, ordered by date with total. How can I get
subtotals for every week?
Thanks
 
1. Open the report in design view.

2. In the Sorting And Grouping pane, select the date field.

3. In the lower part of the pane, choose Yes for group footer, and indicate
you to use the interval Week. Access adds a Group Footer section to the
report.

4. In the new group footer, place the text box to show the total for the
week. The ControlSource will be something like this:
=Sum([Amount])
where you put your own field name in place of Amount.
 
If this is a report question, then you probably should have asked in the
Reports group, but to answer your question, you will need to use Sorting and
Grouping.
Create a Group based on the week, then in the group footer for the week, use
the Sum function for the controls you want to total by week.

To determine the week a date is in, use DatePart("ww",YourDateField)
 
Back
Top