Show 0 in text box if subform count = 0

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

Guest

I have a report with a subreport embedded in the main report. My problem is
that i have a text box on the main report that is using a basic formula to
work out a percentage of the records in the subreport but when there are no
records in the sub report the text box returns an error# value

Can anyone help me?
 
In the text box you can write

=IIf([SubReportName].[Report].[HasData],
[SubReportName].[Report].[TextBoxName] , 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

Help! i cant get Nz function to work in report! 1
Strange report/subreport problem 4
Counting records from a subform to a grouped main form 2
Subreport On No Data 1
Total Costs in Text Box. I get error if values are missing... -- 1
SUBREPORTS' TOTALS' ERRORS 3
Summing a caluated control in a report 1
Reports and SubReports Spacing 6

Back
Top