Access 2007 running sum over group

G

Guest

Anyone experience a problem w/a running sum over a group in an access 2007
report? Text field works fine if set sum for 'Over All', but if set to 'over
group', the control value stays at 1

thanks
 
A

Allen Browne

Dan, I am not able to reproduce that problem.

Tell us more about this text box.
In what section is it placed?
What is its Control Source?
 
G

Guest

Allen:

Thanks for reply...I figured it out. I had an extra grouping "inside"
the grouping I was attempting to rank (this group was hidden and not
printing). Therefore, the value of 1 that I was seeing was actually correct
since it was the 'overall' group, instead of the detail group I wanted.

Once I removed the extra unnecessary grouping, it looked fine.

thanks again!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Total not correct in Footer 1
Can't figure out what I'm doing wrong with running sum 2
Stop running sum(Over All) when customer change 2
Running Sum - Over Group 1
Running Sum 1
Another Running Sum 3
Counting records in group not working - Access 2007/WinXP 4
Reset running sum on group level 2

Top