Running Sum

D

Design by Sue

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?
 
V

Van T. Dinh

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

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