Omit detail if no data

  • Thread starter Thread starter Phil
  • Start date Start date
P

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
 
Set up the report's record source with an equal join so that names that don't
have an associated activity won't show.
 
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
 
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.
 
Back
Top