Subreports and #Error Calculations

[mous]

Hello There

I have a master report which includes two subreports. A sum to minus one subtotal for another is located at the bottom of the report. If one of the sub reports contains no data then it does not display on the master report (which is fine) but it also put the word #Error at the bottom.

Can anyone tell me how to get rid of this field if one of my sub reports are blank?

Thanks

Dawn

 

[Sohaila Taravati]

Lookup nz function

 

[Rich]

Look up the HasData method in help or here