Possible Report Issue

  • Thread starter Thread starter echofuzz
  • Start date Start date
E

echofuzz

Hi. I'm working on a database for a safety audit. The auditors would like to
be able to use some of the tables and subtables as a sort of checklist for
the audits. The table/subtable structure is as follows:

Topic
-->Subtopic
-->ProgramArea
-->ProgramRequirement

I decided to create a report that will output that data. However, the report
is only outputting information if there are ProgramRequirements already
entered for a given ProgramArea. Is there a way to get it to output the
ProgramArea and ProgramRequirement even if blank? Or am I going about this
the wrong way?

Thanks!
Eileen
 
The problem will be with the query that forms the RecordSource for your
report. You'll have an "inner join" between two tables somewhere, and that
only returns results if there is a match. If you open the query in Query
Builder and double-click the join line(s), you'll see other options ("outer
joins").

Phil, London
 
Back
Top