Access 2007 Reports

How do I get rid of a group footer in Access 2007
Who is Participating?
mbizupConnect With a Mentor Commented:
I believe you have to get rid of the header and footer together.

Look at the bottom of the report design... you'll see a Group/ Sort/ Total section.  Click on the More...

If you ONLY want to get rid of the group footer (not the header), set the visible property of the footer to FALSE,
Jeffrey CoachmanMIS LiasonCommented:
Open the Sorting and grouping screen.

Then go here (you may have to click "More"
turn off gropu footer
Jeffrey CoachmanMIS LiasonCommented:
...but like mbizip mentioned, you need to make sure of exactly what you need here.

<How do I get rid of a group footer in Access 2007 >

"Get Rid of", to me, means to delete/remove (a destructive command), as removing the group footer will delete the entire group and all the control within it.
If you ever want it back again, you will have to recreate the group and insert the controls again.

Mbizup's suggestion would simply 'hide" the group, then it is a easy thing to unhide it.

Also note that you can also simple "change" the group in that same section of the Sorting and Grouping options...

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.