If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Possible Report Issue
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 |
#2
|
|||
|
|||
Possible Report Issue
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 "echofuzz" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|