Calculations that include Blank SubReports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

An Access 2003 report consists of several subreports. Each subreport has its
own totals. The bottom of the master report summarizes the data by adding
and subtracting totals from each subreport.

When each subreport contains data, everything works great. However, when
any given subreport contains No Data, final calculations are #error. I have
been unsuccessful in using the IsNull or Nz functions and suspect a No Data
subreport is different than Null.

How can I write the final total expressions so that No Data subreports do
not corrupt the results? Thank you...Linda
 
Test the HasData property of the report in the subreport control:

=IIf([Sub1].[Report].[HasData], Nz([Sub1].[Report].[MyTotal],0), 0)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SynNeed to account for null values in subreports 2
Subreport with no records 8
Access How to prevent subReport from breaking across pages? 1
Subreports 1
Subreport not displaying 5
Displaying blank space when no data in subreport 5
Subreports show up blank 4
No Data on one of 6 Subreports 1

Back
Top