<div>
You can try this in as the Control Source for txtAverage:<br />
<br />
=[txtSumMoldsMade] / (Reports!YourReportName!Yo<wbr />urSubRepor<wbr />tControlNa<wbr />me.Report!<wbr />txtCount)<br />
<br />
Of course, if txtCount can be zero, then you will get #Error ... or if the subreport does not have any records.<br />
<br />
mx
</div>


You can try this in as the Control Source for txtAverage:

=[txtSumMoldsMade] / (Reports!YourReportName!YourSubReportControlName.Report!txtCount)

Of course, if txtCount can be zero, then you will get #Error ... or if the subreport does not have any records.

mx

<div>
 &lt;No points wanted&gt;<br />
And you can see here for a way to deal with errors of the sub has no records:<br />
<br />
<a href="https://www.experts-exchange.com/questions/24843132/Access-reports-handling-fields-with-no-data-in-them.html" rel="ugc">https://www.experts-exchange.com/questions/24843132/Access-reports-handling-fields-with-no-data-in-them.html</a><br />
<br />
JeffCoachman
</div>


<No points wanted>
And you can see here for a way to deal with errors of the sub has no records:

https://www.experts-exchange.com/questions/24843132/Access-reports-handling-fields-with-no-data-in-them.html [https://www.experts-exchange.com/questions/24843132/Access-reports-handling-fields-with-no-data-in-them.html]

JeffCoachman

<div>
Just noting that the syntax I post was correct and will work from anywhere.<br />
<br />
mx
</div>


Just noting that the syntax I post was correct and will work from anywhere.

mx

<div>
<div class="content wysiwyg-content">
I have a field on a report, &quot;txtSumMoldsMade&quot; which I want to divide by a number on a subreport, &quot;txtCount&quot; and show the result in a field on the main report, &quot;txtAverage&quot;<br />
<br />
How?
</div>
</div>


I have a field on a report, "txtSumMoldsMade" which I want to divide by a number on a subreport, "txtCount" and show the result in a field on the main report, "txtAverage"

How?

How divide number on a report by a number on a subreport?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.