Count as zero when no data

[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

 

[Guest]

You can use expressions like:
=IIf(subrpt1.Report.HasData, subrpt1.Report.txtName, 0)