|
| 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
December 31st, 2007, 03:54 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Sum Top Values
My report displays the top 15 values of [NetofReturns]. I have a counter
that begins a new page after the 15th value in the detail section. In the group footer, I need to display the sum of those 15 values along with the group sum =sum([netofreturns] and a calculation of the percentage that the top 15 make up of the group sum. The group sum is not a problem but the sum of the top 15 is. I can display the running sum of the Top 15, but I can't get that 15th sum into the footer. 
|
|
#2
December 31st, 2007, 04:38 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Sum Top Values
pcaguy wrote:
My report displays the top 15 values of [NetofReturns]. I have a counter that begins a new page after the 15th value in the detail section. In the group footer, I need to display the sum of those 15 values along with the group sum =sum([netofreturns] and a calculation of the percentage that the top 15 make up of the group sum. The group sum is not a problem but the sum of the top 15 is. I can display the running sum of the Top 15, but I can't get that 15th sum into the footer. Just reference the top15 value in a group footer text box: =txtTop15 If you are having trouble calculating the top 15 value over the entire group, then set the txtTop15 running sum text box's expression to: =IIf(txtLineCounter = 15, NetofReturns, 0) where txtLineCounter is the =1 running sum text box that you are using to determine when to start a new page. -- Marsh MVP [MS Access]
|
|
#3
January 3rd, 2008, 03:17 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Sum Top Values
Thanks. That's what I needed.
"Marshall Barton" wrote: pcaguy wrote: My report displays the top 15 values of [NetofReturns]. I have a counter that begins a new page after the 15th value in the detail section. In the group footer, I need to display the sum of those 15 values along with the group sum =sum([netofreturns] and a calculation of the percentage that the top 15 make up of the group sum. The group sum is not a problem but the sum of the top 15 is. I can display the running sum of the Top 15, but I can't get that 15th sum into the footer. Just reference the top15 value in a group footer text box: =txtTop15 If you are having trouble calculating the top 15 value over the entire group, then set the txtTop15 running sum text box's expression to: =IIf(txtLineCounter = 15, NetofReturns, 0) where txtLineCounter is the =1 running sum text box that you are using to determine when to start a new page. -- Marsh MVP [MS Access]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
