I have a report selecting data from several tables--a "Main" table with
several supporting tables providing descriptions, costs, etc.  When I run the
report, no data is displayed, even though I know there is data in the tables.

From what I have worked thru, it appears that one of the supporting table
connections is not producing any data.  (In my case, it is simply supposed to
find a description of the value in the Main table.)  This seems to be driving
the entire report to not produce data.  When I remove this connection from
the report, it runs fine.

Is there a way I can test for this type of condition and still allow the
report to run?  In my example, I could display a default description if the
connection does not produce data.  Since this report is designed to audit
data in the tables, this would provide information to the user to determine
the best course of action to correct the problem.

Please be as descriptive as possible as I am not an Access expert.

Thanks.