Total control on report with control on subreport

  • Thread starter Thread starter Deann
  • Start date Start date
D

Deann

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]!)

I've also tried the following:

=([A])+([Reports]![Mainreport]![Subreport]!)

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.
 
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]!)
 
Back
Top