running sum in report

[stephendeloach via AccessMonster.com]

Is there a way I can only show the last field in a running sum total? I have
my report grouped by category and I need to see the total of each category
but dont want to see every sum, just the last one.

 

[Al Campagna]

Stephen,
If your running sum field were... RunSum, and you just want to see the
total (usually in a Group Footer), hide (visible = No) the RunSum in the
detail section, and in the footer use a calculated field to display the
running sum to that point.
Detail ---------------------------------
City Qty MyRunSum (unbound RunningSum)
Boston 200 200 (Hidden)
New York 100 300 (Hidden)
Chicago 50 350 (Hidden)
GroupFooter ------------------------------------
= MyRunSum
--
hth
Al Campagna
Access MVP 2007
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love, and you'll never work a day in your life."

 

[stephendeloach via AccessMonster.com]

My running sum is in my Detail section because my report is grouped by
Category. So when I add it to the report footer it sums all of the groups...

 

[Al Campagna]

Stephen,
Still not quite sure what you looking for. Perhaps if you showed some
sample data, and the result you want to see, that might make it clearer.
You wrote...Then, probably you don't want a Running Sum, but a regular Sum of some
control value on the report... every time a Category "breaks."

For example, let's say you're adding... [SomeNumber], and [SomeNumber] is
not a calculated value.
With...
= Sum([SomeNumber])
in the CATEGORY Footer, you would get a total for EACH category.

With...
= Sum([SomeNumber])
in the REPORT Footer, you would get the sum over the WHOLE report. (all
Categories)
--
hth
Al Campagna
Access MVP 2007
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love, and you'll never work a day in your life."

 

[stephendeloach via AccessMonster.com]

I dont think i have a Category Footer?? In the Detail section I have
1Quantity, 1UnitPrice, Total. Total control source is =([1quantity]*
[1UnitPrice]). It is set to running sum over group. My report is Grouped by
Category. So I have X amount of different Groups in the Report. This is what
I have...

Qty. UnitPrice. Total
1 10.00 10.00
1 10.00 20.00
1 10.00 30.00
and so on..
this is what I am looking for...

Qty. UP. Total
1 10.00
1 10.00
1 10.00 30.00

Am i making more sense? Thanks.

Stephen,
Still not quite sure what you looking for. Perhaps if you showed some
sample data, and the result you want to see, that might make it clearer.
You wrote...Then, probably you don't want a Running Sum, but a regular Sum of some
control value on the report... every time a Category "breaks."

For example, let's say you're adding... [SomeNumber], and [SomeNumber] is
not a calculated value.
With...
= Sum([SomeNumber])
in the CATEGORY Footer, you would get a total for EACH category.

With...
= Sum([SomeNumber])
in the REPORT Footer, you would get the sum over the WHOLE report. (all
Categories)

My running sum is in my Detail section because my report is grouped by
Category. So when I add it to the report footer it sums all of the

[quoted text clipped - 17 lines]

 

[Al Campagna]

Stephen,
You wrote...

My report is Grouped by Category

Given the sample data you supplied... where is the [Category] value you
are Grouping on???
--
hth
Al Campagna
Access MVP 2007
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love, and you'll never work a day in your life."

I dont think i have a Category Footer?? In the Detail section I have
1Quantity, 1UnitPrice, Total. Total control source is =([1quantity]*
[1UnitPrice]). It is set to running sum over group. My report is Grouped
by
Category. So I have X amount of different Groups in the Report. This is
what
I have...

Qty. UnitPrice. Total
1 10.00 10.00
1 10.00 20.00
1 10.00 30.00
and so on..
this is what I am looking for...

Qty. UP. Total
1 10.00
1 10.00
1 10.00 30.00

Am i making more sense? Thanks.

Stephen,
Still not quite sure what you looking for. Perhaps if you showed some
sample data, and the result you want to see, that might make it clearer.
You wrote...

my report grouped by category and I need to see the total of each
category
but dont want to see every sum, just the last one.

Then, probably you don't want a Running Sum, but a regular Sum of some
control value on the report... every time a Category "breaks."

For example, let's say you're adding... [SomeNumber], and [SomeNumber]
is
not a calculated value.
With...
= Sum([SomeNumber])
in the CATEGORY Footer, you would get a total for EACH category.

With...
= Sum([SomeNumber])
in the REPORT Footer, you would get the sum over the WHOLE report. (all
Categories)

My running sum is in my Detail section because my report is grouped by
Category. So when I add it to the report footer it sums all of the

[quoted text clipped - 17 lines]

category
but dont want to see every sum, just the last one.

 

[stephendeloach via AccessMonster.com]

I grouped it when i made the report...? It is groups are in a combo box in
the form.. Is that what you mean? Thanks

Stephen,
You wrote...

My report is Grouped by Category

Given the sample data you supplied... where is the [Category] value you
are Grouping on???

I dont think i have a Category Footer?? In the Detail section I have
1Quantity, 1UnitPrice, Total. Total control source is =([1quantity]*

[quoted text clipped - 44 lines]