running sum on group not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that shows each department and their schedule by day. It
basically has group header "department", and group header "day". Under the
day header it shows everyone scheduled and the time they work, and the total
of their shift. I can get the running sum to work if I put it in the detail
and sum over the group, but then it places it behind each name, and all I
really want is to be able to see the total for that day, not the increasing
value behind each person. I put this in the footer and switched running sum
to over group, but it will only pick up the first persons total. Then for
day two, which would be Monday, it will pick up the total from what was in
the footer for day 1 and add the first record in day 2 to it?? Why is this
not working right?
 
Shanin said:
I have a report that shows each department and their schedule by day. It
basically has group header "department", and group header "day". Under the
day header it shows everyone scheduled and the time they work, and the total
of their shift. I can get the running sum to work if I put it in the detail
and sum over the group, but then it places it behind each name, and all I
really want is to be able to see the total for that day, not the increasing
value behind each person.
Click to expand...


So, the only problem with using Running Sum in the detail is
that you don't want to see the accumulating value, right?
If so, just set the running sum text box's Visible property
to No.
 
That is not the problem and maybe this is not possible, although from what I
read it looks like it is supposed to be. Actually on our report that shows
schedule by employee I have that done so I just see a weekly total in the
report footer and have the running sum hid in the detail section. On our
Schedule by Department Report I have the normal Page header/footer, Report
header/footer-which has a running sum for the entire week, a department
header, and a day header/footer.

It basically shows the schedule broke down by day, Sunday through Saturday.
I put a footer under day to that I could do a running sum by group on each
day. All it will pick up is the first entry in the day though. I've tried
putting the running sum in the detail and also in the footer and it does the
same thing. It is doing a running sum on the field "Total", maybe the name
of the field is throughing it off?? If I just have it in the detail it
works, but then you have to see it for each person that works that day, so
after the first person you have 8, then the second you have 16, etc. I think
all those numbers would confuse people since you only need to look at the
last one.
 
Sorry, but I'm just not grasping the problem here. It
sounds like you're saying that the running sum text box in
the detail section is not summing?? Maybe if you'd post
some sample data and the reults you're getting I might see
things more clearly.

OTOH, I can't see why you're even using running sum in the
first place. Why won't a simple Sum function do the job?
 
The sum in the footer worked how I wanted...thanks. I was going about it the
hard way.

Marshall Barton said:
Sorry, but I'm just not grasping the problem here. It
sounds like you're saying that the running sum text box in
the detail section is not summing?? Maybe if you'd post
some sample data and the reults you're getting I might see
things more clearly.

OTOH, I can't see why you're even using running sum in the
first place. Why won't a simple Sum function do the job?
--
Marsh
MVP [MS Access]


That is not the problem and maybe this is not possible, although from what I
read it looks like it is supposed to be. Actually on our report that shows
schedule by employee I have that done so I just see a weekly total in the
report footer and have the running sum hid in the detail section. On our
Schedule by Department Report I have the normal Page header/footer, Report
header/footer-which has a running sum for the entire week, a department
header, and a day header/footer.

It basically shows the schedule broke down by day, Sunday through Saturday.
I put a footer under day to that I could do a running sum by group on each
day. All it will pick up is the first entry in the day though. I've tried
putting the running sum in the detail and also in the footer and it does the
same thing. It is doing a running sum on the field "Total", maybe the name
of the field is throughing it off?? If I just have it in the detail it
works, but then you have to see it for each person that works that day, so
after the first person you have 8, then the second you have 16, etc. I think
all those numbers would confuse people since you only need to look at the
last one.
Click to expand...
Click to expand...
 
Back
Top