If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
running sum in report
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 |
#3
|
|||
|
|||
running sum in report
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 |
#4
|
|||
|
|||
running sum in report
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 |
#5
|
|||
|
|||
running sum in report
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 |
#6
|
|||
|
|||
running sum in report
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 |
#7
|
|||
|
|||
running sum in report
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 |
Thread Tools | |
Display Modes | |
|
|