Daily, Weekly, Monthly Totals

[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!

 

[Marshall Barton]

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.

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.