View Single Post
  #1  
Old November 24th, 2005, 09:23 AM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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?