Running Sum

[Guest]

I have generated a report of jobs completed for a week, by day. Each day is
a group. I would like to show a total by day, rather than a running total as
is given by the Running Sum. Any thoughts?

 

[Van T. Dinh]

Add a Total / Sum Control in the "Day" GroupFooter. Check your Access Help
/ Access books on "Group Header/Footer".

 

[John Spencer (MVP)]

Well, you might be able to fix this by changing Running Sum to OVER GROUP.
HOWEVER, you would probably be better off following the advice given by Van T. Dinh.

 

[Guest]

Thanks - that worked