Omit detail if no data

[Phil]

Hi,
I have a report that is created from two tables. One table has names and
the other table has activity for the names in the names table. One (names)
to many (activity) relation. My report contains the names and under each
name is the activity (detail section) for that person. The detail section
has three lines of data for each activity. If a person has NO activity I
don't want to display the detail section because it is just blank. How can
I do this?

Thanks,
Phil

 

[Duane Hookom]

Set up the report's record source with an equal join so that names that don't
have an associated activity won't show.

 

[Phil]

Hi Duane,
I want the names to show even if they don't have any activity. I just don't
want the detail section to show if there is no activity.
Thanks

 

[Duane Hookom]

You should be able to add code to the On Format event of the detail section
like:

Cancel = IsNull([Some Detail Field])

This would be entered into the report's module.