calculated control

  • Thread starter Thread starter David
  • Start date Start date
D

David

I have a report "Combined" with a series of calculated
ctl's. These controls count the times a check box is
checked over a date range.

This report has a subreport "ABC Company" which counts the
same check boxes for 1 particular client. What I need
calculated now is the difference between the two for each
check box.

What I've tried will not work..
=([SumOfGrapes])-([Me]![ABCCompany]![SumOfGrapes])

Where am I going wrong??!!

Thanks David
 
The keyword Me only works in the VB editor, it won't work in calculated
controls. Also, to refer to the subreport you need to refer to the control
that holds the subreport which may have a different name than the subreport
itself. The full path to the control on the subreport would be
NameOfSubreportControl.Report!SumOfGrapes. Since you Report is the default
of the subreport control and you are using ! instead of dot, you can
probably get by with just NameOfSubreportControl!SubOfGrapes.
 
Back
Top