<div>
Use this function it is from Excel but behind it all is VBA: modify for your code what is important is the [=If(IsError] part.<br />
<br />
=If(IsError(VLOOKUP(B29,ex<wbr />change,2))<wbr />,&quot;&quot;,VLOOKU<wbr />P(B29,exch<wbr />ange,2))<br />

</div>


Use this function it is from Excel but behind it all is VBA: modify for your code what is important is the [=If(IsError] part.

=If(IsError(VLOOKUP(B29,exchange,2)),"",VLOOKUP(B29,exchange,2))


<div>
Peter: &nbsp;I think you are on it. &nbsp;I will try your solution first tomorrow (PST) and get back to you asap on the points. &nbsp;If you are correct, I'll have to do that for each control that is looking for a sub report field - 48ea. &nbsp;I'm sure the first field will be telling enough to say whether the solution will work or not. &nbsp;Copy and paste (and edit), man! &nbsp;Thanks, guys.
</div>


Peter:  I think you are on it.  I will try your solution first tomorrow (PST) and get back to you asap on the points.  If you are correct, I'll have to do that for each control that is looking for a sub report field - 48ea.  I'm sure the first field will be telling enough to say whether the solution will work or not.  Copy and paste (and edit), man!  Thanks, guys.

<div>
Right on, Peter! &nbsp;Thanks. &nbsp;Sorry for the wait on the points. :o)
</div>


Right on, Peter!  Thanks.  Sorry for the wait on the points. :o)

<div>
<div class="content wysiwyg-content">
I have multiple nested reports whereby all the final sums of the individual reports roll up into fields on the report footer. &nbsp;If any one report has no data an #Error shows in the roll-up sums even though the report doesn't show at all. &nbsp;Either I'd like to Nz() all the fields on the sub reports so that the sums are zero or Nz() the roll-up fields so that the #Error does not show and the field can be used in calculating the grand total. &nbsp;One #Error ripples through the results and I get no Grand Total because ONE field is empty or one row is empty.
</div>
</div>


I have multiple nested reports whereby all the final sums of the individual reports roll up into fields on the report footer.  If any one report has no data an #Error shows in the roll-up sums even though the report doesn't show at all.  Either I'd like to Nz() all the fields on the sub reports so that the sums are zero or Nz() the roll-up fields so that the #Error does not show and the field can be used in calculating the grand total.  One #Error ripples through the results and I get no Grand Total because ONE field is empty or one row is empty.

Suppress #Error result in Access reports

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.