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 wrote:

>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.

--
Marsh
MVP [MS Access]