Suppress some footers in reports

  • Thread starter Thread starter Helen
  • Start date Start date
H

Helen

I have a report which totals details to subgroups,
subgroups to sections, and sections to pages. How can I
suppress the section total if it contains only one
subgroup, i.e. subgroup total and section are the same?

Thanks, Helen
 
Place a text box in the group footer for the "sections" bit of your report.
Give it these properties:
ControlSource =1
Running Sum Over Group
This should give you a count of the number of sections in the subgroup.

Now in the subgroup total's group footer's Format event procedure, you can
include some code to set PrintSection to No if this text box = 1.
 
Back
Top