Showing a Null result

[paul bennett]

I have a parent table linked to several child tables via a unique text string

The report shows reults from the main table, and has subreports for the
child tables.

Some records in the parent table have no equivalents in the child tables.
Can I insert some code to produce the subreports with a "None" or "NA" text
string, without populating the child tables with these terms?

My problem is that, I need to run "counting" queries on the child tables,
but the "N/A" records skew the numbers by adding records where there should
be none.

 

[Duane Hookom]

I'm not sure what your specific requirement is. You can use the HasData
property of the subreport control to determine if there are records in your
subreport.

This expression will display nothing if the subreport has data and a message
if there is no data.
=IIf(subrptControl.Report.HasData, Null, "No data in subrptA")

 

[paul bennett]

The parent is a physical area with several pieces of information, which are
displayed in the main (detail) section of the report.
The child is a table listing the buildings in that area and is shown in a
sub-report as a continuous form.

Presently, where there is an area with no buildings, the building sub-report
does not appear at all.

I want a report that will show the buildings in an area in the sub-report,
if there are no buildings there, to say "None Present" where the sub report
would have been

 

[Duane Hookom]

Did you attempt exactly what I suggested only changing it to reference your
subreport control name?

=IIf(subrptControl.Report.HasData, Null, "None Present")

 

[paul bennett]

Still does not return a null result - what am I doing wrong?

Enter main report in design view
Right click on sub-form (Form.tblConservationAreasCONS subreport)
"build event"

Private Sub Form_Load()
=IIf(CONS_CharacterAreaNumber.tblConservationAreasCONS_subreport.HasData,
Null, "None Present")

End Sub


Compile Error
Expected: Line Number or Label or Statement or end of statement

 

[Duane Hookom]

Quite often when I post code to be pasted into a module, users will attempt
to place it in an event "property". In your case, I should have been more
clear that this was a text box and the Control Source property should be set
to:
=IIf(tblConservationAreasCONS_subreport.Report.HasData, Null, "None Present")
This assumes your subreport control name is
"tblConservationAreasCONS_subreport".

 

[paul bennett]

Thanks for that, I was using a form as the subreport, once I changed it to a
report, this worked fine. Cheers Duane