Report If Null, Zero Value

[stevemccauley]

I have a report"A", that when opened, opens another report"B" and minimizes it. Report"A" then uses a textbox(from report"B") in a calculation. My problem is that sometimes report"B" is empty and the textbox with the total for my calc on report"A" shows an ERROR message. What can I do to have this textbox show a zero instead of ?Error?

Thanks,
Steve

 

[Fizzio]

Try using Nz function (Null to Zero)

In controlsource of txtbox use Nz(Calculation or field)

 

[stevemccauley]

The whole report is Null, but I still want to have the grand total to equal zero. the nz function didn't work because there is an ?ERROR message in all the textboxes on the report. Can i write some type of code in the Report IsNull section of the report so that the grand total is either the total of the calculation of zero?

 

[Rich]

Have you tried the HasData method?

 

[stevemccauley]

I used Iif IsError formula and its working now

Thanks
Steve

 

[Rich]

The IsError might work, I'm not so sure it's an appropriate use of the function