running sum in report

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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200707/1

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" u32891@uwe wrote in message
news:7551c323f511d@uwe...
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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200707/1

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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200707/1

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)
--
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" u32891@uwe wrote in message
news:75528de0aa654@uwe...
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 wrote:
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
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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200707/1

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.

Al Campagna wrote:
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.

--
Message posted via http://www.accessmonster.com

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."


"stephendeloach via AccessMonster.com" u32891@uwe wrote in message
news:755c05b4d52db@uwe...
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.

Al Campagna wrote:
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.

--
Message posted via http://www.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

Al Campagna wrote:
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]
category
but dont want to see every sum, just the last one.

--
Message posted via http://www.accessmonster.com