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

 

[tina]

just saw your post by chance, David. i usually "un-watch" threads after a
week or two of inactivity, but i've been too busy to go thru and clean up
the groups in my newsreader. <g>

glad the =Sum() solution worked for you. re the RunningSum issue, i've no
idea why it's not working as the Help seems to say it will. (maybe i'm
reading the Help topic wrong.) i was just working on a report today and ran
into the same issue. i only fiddled with it briefly before using the =Sum()
solution, myself. when i'm working on a "real" db (not a newsgroup
question), especially with a deadline, i tend to only spend so much time
trying to figure out why something won't work. then i just say "well,
whatever" and find another way to do it! <bg>

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


tina wrote:
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]

Fair enough and my problem is solved, but nonetheless I am curious to
know whether I am misunderstanding the "overgroup" issue or whether my
software isn't working for some reason and perhaps I should re-install it.

Maybe someone can help?

Thanks

David

just saw your post by chance, David. i usually "un-watch" threads after a
week or two of inactivity, but i've been too busy to go thru and clean up
the groups in my newsreader. <g>

glad the =Sum() solution worked for you. re the RunningSum issue, i've no
idea why it's not working as the Help seems to say it will. (maybe i'm
reading the Help topic wrong.) i was just working on a report today and ran
into the same issue. i only fiddled with it briefly before using the =Sum()
solution, myself. when i'm working on a "real" db (not a newsgroup
question), especially with a deadline, i tend to only spend so much time
trying to figure out why something won't work. then i just say "well,
whatever" and find another way to do it! <bg>

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


tina wrote:
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]

somebody else might be able to shed light on this issue, but you probably
won't get a response in this thread, because it's so old. you might want to
start a new thread in this newsgroup, to see if you can get any help.

Fair enough and my problem is solved, but nonetheless I am curious to
know whether I am misunderstanding the "overgroup" issue or whether my
software isn't working for some reason and perhaps I should re-install it.

Maybe someone can help?

Thanks

David

just saw your post by chance, David. i usually "un-watch" threads after a
week or two of inactivity, but i've been too busy to go thru and clean up
the groups in my newsreader. <g>

glad the =Sum() solution worked for you. re the RunningSum issue, i've no
idea why it's not working as the Help seems to say it will. (maybe i'm
reading the Help topic wrong.) i was just working on a report today and ran
into the same issue. i only fiddled with it briefly before using the =Sum()
solution, myself. when i'm working on a "real" db (not a newsgroup
question), especially with a deadline, i tend to only spend so much time
trying to figure out why something won't work. then i just say "well,
whatever" and find another way to do it! <bg>

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

tina wrote:
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


tina wrote:
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