One Portion of Select Fails

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You have a report based on a query that includes multiple tables?

There are 2 issues that could cause the query to not produce any records for
the report: using an inner join (you need an outer join), and using criteria
on fields with Null.

For details on how to solve both issues, see:
The Query Lost My Records!
at:
http://members.iinet.net.au/~allenbrowne/casu-02.html
 
Back
Top