Hope I can explain my problem.
I have a main report for a number of sites.
It has 5 sub reports some of which may not contain data for a particular site.
Would like to indicate on the report that there is no data for this site on 
this sub report.
-- 
Alex Paszkiewicz

Create a text box on the main report, and set its Control Source to 
something like this:
    =IIf([Sub1].[Report].[HasData], Null, "Nothing for this site.")

Replace Sub1 with the name of your subreport control.

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Syspol Consultants" <SyspolConsultants@discussions.microsoft.com> wrote in 
message
news:5EC9C229-017C-41E4-867F-F0F0877EE83E@microsoft.com...
> Hope I can explain my problem.
> I have a main report for a number of sites.
> It has 5 sub reports some of which may not contain data for a particular 
> site.
> Would like to indicate on the report that there is no data for this site 
> on
> this sub report.
> -- 
> Alex Paszkiewicz