Sub Reports with no Data

[Dave]

Access 2003

Would like to be able to populate a report with text ("Sorry - there were no
incidents this month") if the sub report is empty (contains no data)

How can this be done easily?

Any help here will be appreciated.

Thanks in advance


dave

 

[Duane Hookom]

You can use a text box on the main report with a control source like:
=IIf(subrptControlName.Report.HasData,Null,"Sorry -there....")

 

[Dave]

Thanks you - I will try that

dave

You can use a text box on the main report with a control source like:
=IIf(subrptControlName.Report.HasData,Null,"Sorry -there....")