T
Tom
In a report, I created a text box named "Anticipated" ... this text box
calculates information from other fields in the report
{=([premium]*[comm]/365)*((Now()-30)-[eff date])}. I would like to create a
new text box to Sum the total of the "Anticipated" boxes.
Here is how it is grouped;
Name Header
Eff Date Header
[Anticipated]
Detail
Name Footer
[SumAnticipated]
The SumAnticipated text box prints empty ... I am sure it is how I am
referring to the [Anticipated] text box, but I have been unable to get
around it. I have tried =Sum([Reports]![rptExpected Commissions
Summary].[Anticipated]) and other variations, but I am missing something.
Your help is very much appreciated!
Thanks,
Tom
calculates information from other fields in the report
{=([premium]*[comm]/365)*((Now()-30)-[eff date])}. I would like to create a
new text box to Sum the total of the "Anticipated" boxes.
Here is how it is grouped;
Name Header
Eff Date Header
[Anticipated]
Detail
Name Footer
[SumAnticipated]
The SumAnticipated text box prints empty ... I am sure it is how I am
referring to the [Anticipated] text box, but I have been unable to get
around it. I have tried =Sum([Reports]![rptExpected Commissions
Summary].[Anticipated]) and other variations, but I am missing something.
Your help is very much appreciated!
Thanks,
Tom