Sub Report

A

Abe Katz

Hello,
I want to display something on the main Report if there is no details in the
sub report.
How can I check, when the report opens if there is no detail in the sub
report.
I tried to put a sum field in the sub and check if > zero, but it doesn't
always work when there is multiple records to print.
Thanks
Abe
 
A

Allen Browne

Try a text box with Control Source like this:

=IIf([Report].[HasData], Null, "Oops: nuffin 2 C.")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Snaking Columns Report 1
Can Shrink in sub-report 1
Trouble with Report Preview Button on sub form 1
set sub report height 0
Problem with Report and Forms 2
Print button on Report form 3
Opening a filterable report from a form 5
Access Access Report Works on One Machine but not Another 3

Top