Show Group Footer Only on First Occurance

  • Thread starter Thread starter moniman01
  • Start date Start date
M

moniman01

I have several group footer in an Access report and am only showing values in
the first occurence. This is causing gaps where the values are blank farther
down the report. Is there a way to only show a group footer on the first
occurance and then suppress/hide it. Any help or suggestions are appreciated.
 
If I understand correctly, I would add a text box in the Group Footer section:
Name: txtGroupFooterCount
Control Source: =1
Running Sum: Over All
Visible: No
Then add code to the On Format event of the Group Footer:
Me.Cancel = Me.txtGroupFooterCount > 1
 
Back
Top