Daily, Weekly, Monthly Totals

  • Thread starter Thread starter jlo
  • Start date Start date
J

jlo

I am trying to create a report that shows daily, weekly, monthly totals by
dtmCreationDate.

So far it does calculate daily totals by the sorting and grouping box set to
Day. I then need to know how to get it to recognize weeks and give a total
as well as the entire month.

I am really struggling at this.

Thanks!
 
jlo said:
I am trying to create a report that shows daily, weekly, monthly totals by
dtmCreationDate.

So far it does calculate daily totals by the sorting and grouping box set to
Day. I then need to know how to get it to recognize weeks and give a total
as well as the entire month.
Click to expand...


Try adding more groups. First one for months using an
expression like =Format(dtmCreationDate, "yyyymm"), second
group using =DatePart("ww", dtmCreationDate) and the third
group as the one you have now. Then the group header and/or
footer sections can display the various totals by using the
same expression you have for the daily total.
 
Back
Top