Program Analyst

Sherry McCain

<div>
<div class="content wysiwyg-content">
I have a report with 7 sub reports. My main report contains &nbsp;calculated controls that uses totals from fields in the different sub reports. The controls calculate when in layout view, but in print preview &nbsp;I receive the &quot;#Type!&quot; error. I know it's because some sub reports don't have data but I still need it to calculate and show on my report when printed.<br />
<br />
&nbsp;How do I get it to display on my report when printed?<br />
<br />
This is my expression I use in expression builder as my control source for the text box:<br />
=[subrptTIPS].[Report]![YT<wbr />D TIP Score]*15
</div>
</div>


I have a report with 7 sub reports. My main report contains  calculated controls that uses totals from fields in the different sub reports. The controls calculate when in layout view, but in print preview  I receive the "#Type!" error. I know it's because some sub reports don't have data but I still need it to calculate and show on my report when printed.

 How do I get it to display on my report when printed?

This is my expression I use in expression builder as my control source for the text box:
=[subrptTIPS].[Report]![YTD TIP Score]*15

MS Access #Type! error on report with subreports

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.