Count as zero when no data

  • Thread starter Thread starter Mike Green
  • Start date Start date
M

Mike Green

Hi all
I have a report based on several tables. The tables hold information
onJobs, work and parts respectivly. The main report calculates totals based
on the content of the sub reports that are sub reports and all is well
until..
If there is no data in one of the sub reports. How do I get the
calculations in the main report to treat the value of the missing report,
whichever one it is, as zero?
I was thinking of NZ but I not sure if that is the correct way to go?

Any assistance is appreciated

Mike
 
You can use expressions like:
=IIf(subrpt1.Report.HasData, subrpt1.Report.txtName, 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

Access Access Report Works on One Machine but not Another 3
Reports, Sub-reports running sum and no data 2
Subreport On No Data 1
Checkboxes that return zero are counted as 1 in my report 1
Access Sorting and grouping using multiple tables 0
Parameter Query - Report 4
#Error is diplayed instead of zero (0) on report from subreport. 2
Null Return on Count Function 4

Back
Top