Calculation using Child and Parent

[SamanthaSamuels]

Hi.



I have a report that has a child report in it. I want to calculate a percentage from the main and child report. Perhaps I just don't know the syntext.

Does anyone know how this can be accomplished?

Thanks in advance.

[ryan1313]

Where do you want the calculation? If in the detail of the Parent, create a text box for the calculation and in the On Print event of the details properties add the code:

Me.txtCalculation = [Reports]![YourParentReportName]![YourChildREportName].Report.[YourChildFieldName] / Me.txtFieldName

[SamanthaSamuels]

Thanks! It worked! Awesome!

[ryan1313]

You are welcome! Glad I could help!