Multiply data in a report from 2 seperate reports

[ye2127]

Hi,
I have a report called 'schools'

This report lists the percentage of schools performing a certain action

In the 'schools' report I have a subreport which lists information on the percentage of classes performing a certain action.

Thus the 'schools' report contains an output value of the percentage of classes performing a certain action and the percentage of schools performing the same action.

Is there any way I can multiply the percentage of schools performing a certain action by the percentage of classes performing a certain action and display this in the same report?

The 'schools' report uses fields from 'schools' query while 'classes' report uses fields from the 'classes' query.

Please help me find a way to multiply the two percentage values and display them in the same report.

Thanks

[ye2127]

To clear it up a bit more.
The 'class' report is a subreport containing a percentage value that is displayed in the 'schools' report.

The 'class' report contains information from the 'class' query.
The 'school' report contains information from the 'school' query.

Is there a way i can multiply the output values from the two reports and display them in my report?

Is there any other way i can go about this so as to multiply the values from two seperate queries which stem from two seperate tables?

[MMcCarthy]

To clear it up a bit more.
The 'class' report is a subreport containing a percentage value that is displayed in the 'schools' report.

The 'class' report contains information from the 'class' query.
The 'school' report contains information from the 'school' query.

Is there a way i can multiply the output values from the two reports and display them in my report?

Is there any other way i can go about this so as to multiply the values from two seperate queries which stem from two seperate tables?

Firstly create a new textbox to hold the value. Then if the textbox is on the subform then set the control source equal to

=[PercentTextboxOnSubReport] * [Reports]![School]![PercentTextboxOnSchoolReport

or if the new textbox is on the main form them

=[PercentTextboxOnSchoolReport] * [Reports]![School]![PercentTextboxOnSubReport

Mary

[PEB]

Hi,

I've always prefered to do all calculations and transformations into a queries rather than in reports!

The codings and calculations in reports are always not able to fit a big amounts of data!

Queries are always more performing! There is cases when query opens but report can't open giving an error Query is too complex!

So try to create a query on using shcool and class queries where to calculate the respective values.

And than create a report that shows those calculations!

Certenly in some cases the report shows the percent calculations easy! But watching the answer of Mary it seem to be more complicated ur case! So seems for me better to calculate into a query!

Exemple of calculation column into query:

Total score: [shcool].[score]*[Class].[Score]


Best regards!

To clear it up a bit more.
The 'class' report is a subreport containing a percentage value that is displayed in the 'schools' report.

The 'class' report contains information from the 'class' query.
The 'school' report contains information from the 'school' query.

Is there a way i can multiply the output values from the two reports and display them in my report?

Is there any other way i can go about this so as to multiply the values from two seperate queries which stem from two seperate tables?