Access 2007 Reports

How do I get rid of a group footer in Access 2007
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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,

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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...

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.