In report, how to have a count return something other than null

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

Guest

I have a subreport that holds a count of names at the end of the report that
I want to reference in the main report to add it. My problem is that
sometimes this subreport ends up being null - there aren't always entries.
Can i have the count give a value of zero if it is null so it doesn't give me
that #Error and screw up my counts in the main form? I tried nz, and iif
statment, etc but can't seem to make anything work.

Thanks!
 
When there are no records in the subreport, nothing shows, and so trying to
refer to the non-existent text box generates #Error.

To avoid that, test the HasData property of the report in the subreport
control:
=IIf([Sub1].[Report].[HasData], Nz([Sub1].[Report]![Text0],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

Null records give Count - #error - is there a way to fix? 7
Help! i cant get Nz function to work in report! 1
Null in answer. 5
Counting Unduplicate in Fiscal Year 1
Report asks for Parameter and Won't Display Subreport 7
Count(*) 1
Reports and SubReports Spacing 6
Null 3

Back
Top