Unanswered: how to refer to a field in the subreport from the main report
I want to calculate the percentage for a field in one of my report.
The report has got a textbox A, and the subreport has got the textbox B. I have to calculate the percentage for a field 'C' which is in the report.
The value for field C = (Value in fieldA/Value in FieldB)*100
The problem is I am not sure how to refer the field B in my formula, since it is in the subreport(recordsource for subreport: qryTotal).
Any clue or idea is really appreciated.
Thanks in advance.