|
| 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
November 24th, 2005, 09:23 AM
posted to microsoft.public.access.reports
|
|||
|
|||
Subreport Expressions
I have a subreport called subrpt_abc
Its embedded in a report called rpt_main. The subreport has a calculated field called TotalACost. The main report also has a calculated field called TotalPanelCost. I wanted to be able to add these two values together. It only seems to work when I create a Grand Total field in the subreport only. However the expression I used does not work. I used: =Reports!rpt_main!TotalPanelCost!+TotalACost Note: when my mouse cursor exits the Control source field, the expression all of a sudden has brackets: ie =[Reports]![rpt_main]![TotalPanelCost]!+[TotalACost] I think these brackets cause the error in giving me the required total value amount. Why are these brackets appearing? 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Parameterizing subreports | Jack | Setting Up & Running Reports | 8 | October 21st, 2005 12:00 PM |
| Printing Subreport without data | CCross | Setting Up & Running Reports | 2 | June 1st, 2005 06:04 PM |
| repeating records in a subreport | Paul James | Setting Up & Running Reports | 2 | February 2nd, 2005 06:11 PM |
| SubReport No Data printing problem | Tony_VBACoder | Setting Up & Running Reports | 1 | August 9th, 2004 10:10 PM |
| Problems totalling subreport data on main report (A-2002) | Marshall Barton | Setting Up & Running Reports | 0 | June 23rd, 2004 08:01 PM |
Threaded Mode