Running Sum.

  • Thread starter Thread starter RRogers
  • Start date Start date
R

RRogers

I am having a problem with a report that I have several
groups, and I wish to do a running sum of a field in each
group, then reset to zero and start over for the next
group, so that each line item in the group totals into one
field.

I have tried using the "over group" setting, and I have
tried using the "over all setting" in either case is
registers the first line item only, and does not see the
rest of the line items.

I have also tried placing my totals field in a group
footer, group header, and in the detail block as well with
the same effect.

If anyone has any ides how I can fix this problem, I would
greatly appreciate it. Please feel free to e-mail me at
the (e-mail address removed).

Thanks.
 
What is the Control Source of the thing you are trying to sum? Is it a
calculated control on the form, or a calculated field in the source query?

If so, there is a good chance that Access is not understanding the data type
correctly. Try wrapping the calculation in a type conversion function. For
example, if the source field is:
[Quantity] * [UnitPrice]
change it to:
CCur(Nz([Quantity] * [UnitPrice], 0))
Setting the Format property of the text box to Currency (or General Number)
may also help.

Setting the Running Sum of the text box to Over Group sounds like what you
need to do. This is also assuming that the text box is in the Detail Section
(or at least an inner section compared to where you want the total).
 
Back
Top