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
|
|||
|
|||
Sub Reports
Is it possible to calculate a total in a main report from data that is in an
attached sub report? If it is, can you point me to some examples so that I can understand the syntax? -- Don Rountree |
#2
|
|||
|
|||
Sub Reports
Don wrote:
Is it possible to calculate a total in a main report from data that is in an attached sub report? If it is, can you point me to some examples so that I can understand the syntax? The subreport must calculate its own total in it report footer section. A main report text box (named txtRunTotal) in the same section as the subreport can refer to the subreport total by using an expression like: =IIf(subreport,Report.HasData, subreport,Report.total, 0) and set the its RunningSum property to Over All To display the grand total in the main report's footer section, use a text box with the expression: =txtRunTotal -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Emailing PDF reports from Access | CraigMc | General Discussion | 6 | October 11th, 2007 12:52 AM |
Report Filter | ACase | Setting Up & Running Reports | 3 | October 27th, 2005 08:51 PM |
Some users cannot run reports | Frank | Setting Up & Running Reports | 11 | October 22nd, 2005 03:46 AM |
Print a series of reports based on a single date and a series of numbers | Bill R via AccessMonster.com | Setting Up & Running Reports | 1 | September 9th, 2005 12:53 AM |
REPOST: Maintaining Page Numbers with multiple reports. | Robin Chapple | Setting Up & Running Reports | 1 | August 5th, 2005 06:53 AM |