Show Group Footer Only on First Occurance

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.
 
D

Duane Hookom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Force the group footer to print on the first page 5
How to "copy" group running total to report footer? 3
Group Footer Summarizing Problem 5
REPORT FOOTER ON SEPARATE PAGE 1
Group last line of details and report footer 0
Starting a new group on a new page 1
Different size page footer on first page 6
Show Maximum Number in Report Footer 1

Top