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
I have created a report and I want to print in the page header and footer
sums of the detail section. In the footer I want to print the running sum of the detail section so far and in the header I want to print the running sum of previous pages. Thanks in advance Dimitris Nikolakakis |
#2
|
|||
|
|||
Dimitri,
Assuming the control holding the amount is named Text1, create a second one next to it in the detail section, with the same Control Source property, and set its Running Sum property to Over All; this should display the running sum. I'll assume this is named Text2. When you are happy that this is working correctly, set its Visible property to No, so it doesn't show on the report. Then add a text box in each of the page header and footer sections, and set the Control Source property on both to: =[Text2] (or whatever the actual name of the running sum control). This should do it. HTH, Nikos Dimitris Nikolakakis wrote: I have created a report and I want to print in the page header and footer sums of the detail section. In the footer I want to print the running sum of the detail section so far and in the header I want to print the running sum of previous pages. Thanks in advance Dimitris Nikolakakis |
#3
|
|||
|
|||
I have tried it and the result is...
In the first page the running sum in the footer is OK. In the second page, the running sum in header is the R.S. of previous page footer plus the first line of the details. Thanks in advance Dimitris Ο "Dimitris Nikolakakis" έγραψε στο μήνυμα ... I have created a report and I want to print in the page header and footer sums of the detail section. In the footer I want to print the running sum of the detail section so far and in the header I want to print the running sum of previous pages. Thanks in advance Dimitris Nikolakakis |
#4
|
|||
|
|||
Hmm.... I've seen this before, and thought I was doing something wrong!
It seems Access isn't very good at prioritizing events, apparently it formats the page header after it's done so for the first detail. I'm afraid I don't have a solution. Dimitris Nikolakakis wrote: I have tried it and the result is... In the first page the running sum in the footer is OK. In the second page, the running sum in header is the R.S. of previous page footer plus the first line of the details. Thanks in advance Dimitris Ο "Dimitris Nikolakakis" έγραψε στο μήνυμα ... I have created a report and I want to print in the page header and footer sums of the detail section. In the footer I want to print the running sum of the detail section so far and in the header I want to print the running sum of previous pages. Thanks in advance Dimitris Nikolakakis |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Query Help.. Creating a running Total Field????? | Darryn Ross | Running & Setting Up Queries | 8 | October 28th, 2004 07:54 AM |
query to calc running total | jmd | Running & Setting Up Queries | 1 | October 23rd, 2004 11:09 PM |
report / running sum and sorting | Wim Foblets | General Discussion | 1 | October 6th, 2004 02:11 PM |
Running Excel vba within IE | Dave Peterson | Setting up and Configuration | 10 | March 25th, 2004 01:38 PM |
Subracting two running totals | Joe | Worksheet Functions | 1 | September 26th, 2003 04:50 AM |