Prev: NotInList to requery in a Bound ComboBox
Next: sorting hyphenated numbers
From: echofuzz on 10 Dec 2009 16:21
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
From: Philip Herlihy on 10 Dec 2009 16:27
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" <echofuzz(a)discussions.microsoft.com> wrote in message
news:62D28718-14AA-42CA-900E-52A66272139F(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: NotInList to requery in a Bound ComboBox
Next: sorting hyphenated numbers