Running sum property - Access 2003

[David Stanton]

I am trying to sum the contents of a textbox into a "total" textbox
across a group by using the "running sum" property set to "group".

It is giving the cumulative sum all through the report.

There is no difference between the "group" and "total cumulative sum"
settings (I forget exactly what Access calls it) - both settings give
the same result.

Also the summing process seems to omit the very first detail line (the
very first record) - the rest are added OK, although cumulated.

Am I missing something or is my software not working properly?

Also what should I put in as the "Control Source" , for example:

[fieldname] or =[fieldname]

=sum([fieldname)]

or [sourcetextboxname], or =[sourcetextboxname]

etc

Many thanks in advance for suggestions

David

 

[tina]

in report design view, open the Sorting and Grouping box. enter the field or
expression you want to group on, and in the Group Properties section (bottom
of the box) set the Group Header property to Yes. close the box.

if you don't want "space" between your groups of detail records, you can
"close" the Header section of the report by dragging the Detail section's
title bar up.

in the detail section, setting the textbox's ControlSource to [fieldname]
should work ok. set the RunningSum property to OverGroup.

hth

I am trying to sum the contents of a textbox into a "total" textbox
across a group by using the "running sum" property set to "group".

It is giving the cumulative sum all through the report.

There is no difference between the "group" and "total cumulative sum"
settings (I forget exactly what Access calls it) - both settings give
the same result.

the settings are Over Group, and Over All (and No, for a "normal" textbox).

Also the summing process seems to omit the very first detail line (the
very first record) - the rest are added OK, although cumulated.

Am I missing something or is my software not working properly?

besides setting up the textbox in the report's Detail section, you h

Also what should I put in as the "Control Source" , for example:

[fieldname] should work fine.

[fieldname] or =[fieldname]

=sum([fieldname)]

or [sourcetextboxname], or =[sourcetextboxname]

etc

Many thanks in advance for suggestions

David

 

[David Stanton]

Yes I've done that! The "running total" textbox is in fact in the
"(groupname)" footer referring to a textbox in the "detail" section.
What is happening is that it isn't resetting to zero after each group
completes, so the amount accumulates. The "overgroup" and "overall"
settings work the same way - as "overall". Also the very first record is
omitted - the first "runningtotal" textbox is short by that much.

David

in report design view, open the Sorting and Grouping box. enter the field or
expression you want to group on, and in the Group Properties section (bottom
of the box) set the Group Header property to Yes. close the box
in the detail section, setting the textbox's ControlSource to [fieldname]
should work ok. set the RunningSum property to OverGroup.

hth

I am trying to sum the contents of a textbox into a "total" textbox
across a group by using the "running sum" property set to "group".

It is giving the cumulative sum all through the report.

There is no difference between the "group" and "total cumulative sum"
settings (I forget exactly what Access calls it) - both settings give
the same result.

the settings are Over Group, and Over All (and No, for a "normal" textbox).

Also the summing process seems to omit the very first detail line (the
very first record) - the rest are added OK, although cumulated.

Am I missing something or is my software not working properly?

besides setting up the textbox in the report's Detail section, you h

Also what should I put in as the "Control Source" , for example:

[fieldname] should work fine.

[fieldname] or =[fieldname]

=sum([fieldname)]

or [sourcetextboxname], or =[sourcetextboxname]

etc

Many thanks in advance for suggestions

David

 

[tina]

ah, i see. i thought, incorrectly, that the "running total" textbox was
located in the Detail section of the report. okay, try this:

make sure the textbox in the Detail section has its' RunningSum property set
to No.
in the group Footer section, also set that textbox's RunningSum property to
No. set the textbox's ControlSource to
=Sum([DetailSectionTextboxName])

hth

Yes I've done that! The "running total" textbox is in fact in the
"(groupname)" footer referring to a textbox in the "detail" section.
What is happening is that it isn't resetting to zero after each group
completes, so the amount accumulates. The "overgroup" and "overall"
settings work the same way - as "overall". Also the very first record is
omitted - the first "runningtotal" textbox is short by that much.

David

in report design view, open the Sorting and Grouping box. enter the field or
expression you want to group on, and in the Group Properties section (bottom
of the box) set the Group Header property to Yes. close the box
in the detail section, setting the textbox's ControlSource to [fieldname]
should work ok. set the RunningSum property to OverGroup.

hth

I am trying to sum the contents of a textbox into a "total" textbox
across a group by using the "running sum" property set to "group".

It is giving the cumulative sum all through the report.

There is no difference between the "group" and "total cumulative sum"
settings (I forget exactly what Access calls it) - both settings give
the same result.

the settings are Over Group, and Over All (and No, for a "normal" textbox).

Also the summing process seems to omit the very first detail line (the
very first record) - the rest are added OK, although cumulated.

Am I missing something or is my software not working properly?

besides setting up the textbox in the report's Detail section, you h

Also what should I put in as the "Control Source" , for example:

[fieldname] should work fine.

[fieldname] or =[fieldname]

=sum([fieldname)]

or [sourcetextboxname], or =[sourcetextboxname]

etc

Many thanks in advance for suggestions

David

 

[David Stanton]

Hi Tina

Apologies for not posting before, but yes, that seems to work and has
done the trick!! The report is pretty much how I want it.

Many thanks.

I don't understand why the "overgroup" parameter won't work, though.
I've tried it in both the "detail" and "group footer" sections.

David

ah, i see. i thought, incorrectly, that the "running total" textbox was
located in the Detail section of the report. okay, try this:

make sure the textbox in the Detail section has its' RunningSum property set
to No.
in the group Footer section, also set that textbox's RunningSum property to
No. set the textbox's ControlSource to
=Sum([DetailSectionTextboxName])

hth

Yes I've done that! The "running total" textbox is in fact in the
"(groupname)" footer referring to a textbox in the "detail" section.
What is happening is that it isn't resetting to zero after each group
completes, so the amount accumulates. The "overgroup" and "overall"
settings work the same way - as "overall". Also the very first record is
omitted - the first "runningtotal" textbox is short by that much.

David

in report design view, open the Sorting and Grouping box. enter the field or
expression you want to group on, and in the Group Properties section (bottom
of the box) set the Group Header property to Yes. close the box
in the detail section, setting the textbox's ControlSource to [fieldname]
should work ok. set the RunningSum property to OverGroup.

hth


I am trying to sum the contents of a textbox into a "total" textbox
across a group by using the "running sum" property set to "group".

It is giving the cumulative sum all through the report.

There is no difference between the "group" and "total cumulative sum"
settings (I forget exactly what Access calls it) - both settings give
the same result.
the settings are Over Group, and Over All (and No, for a "normal" textbox).
Also the summing process seems to omit the very first detail line (the
very first record) - the rest are added OK, although cumulated.

Am I missing something or is my software not working properly?
besides setting up the textbox in the report's Detail section, you h

Also what should I put in as the "Control Source" , for example:
[fieldname] should work fine.

[fieldname] or =[fieldname]

=sum([fieldname)]

or [sourcetextboxname], or =[sourcetextboxname]

etc

Many thanks in advance for suggestions

David