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
|
|||
|
|||
Total control on report with control on subreport
I have a report/subreport where the report has a control
with a number in it (A) and the subreport has a control with another number in it (B). I had the following formula in control C on the main report and it used to work before my system was upgraded to Access 2003. =[A])+([Report]![Subreport]![b]) I've also tried the following: =([A])+([Reports]![Mainreport]![Subreport]![b]) The results that I receive is the total of "A" only. It's as if it can't find a number in "B". Has the syntax changed? I've search the help and can't find anything different. Any advice would be greatly appreciated. |
#2
|
|||
|
|||
Total control on report with control on subreport
Found the answer to my own question. Thanks. I found that
someone else had the same question on May 14th under the subject "Calculated Control" and it worked. In essence -- for those looking for the answer. My formula changed to: =([A])+([Subreport].[Report]![b]) -----Original Message----- I have a report/subreport where the report has a control with a number in it (A) and the subreport has a control with another number in it (B). I had the following formula in control C on the main report and it used to work before my system was upgraded to Access 2003. =[A])+([Report]![Subreport]![b]) I've also tried the following: =([A])+([Reports]![Mainreport]![Subreport]![b]) The results that I receive is the total of "A" only. It's as if it can't find a number in "B". Has the syntax changed? I've search the help and can't find anything different. Any advice would be greatly appreciated. . |
Thread Tools | |
Display Modes | |
|
|