MS Access Group Footer not showing

Experts,

For some reason my reports group footer is not showing (see screenshot). I need to do some subtotals. How do I get the footer to show.

Thanks!
screenshot.png
shogun5Asked:
Who is Participating?
 
Dale FyeConnect With a Mentor Commented:
In Access 2007, you have to click the Group & Sort button on the Design tab of the Ribbon bar.  Then, you should see the Group, Sort, and Total options at the bottom of the page.  In the group you already have defined, click the arrow next to "More", then select "with a footer"
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
In the sorting/grouping options, set the group footer property to yes.
JimD.
0
 
shogun5Author Commented:
Sorry...but where do I find the the sorting/grouping options? I don't see it on the form's properties.
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
AccessYourBiz_ComConnect With a Mentor Commented:
Under the DESIGN tab, click on Group & Sort button, then click on the group name you are working with at the bottom of the screen. You will see a drop down for "without a footer section". Click on the down arrow to the right of this and choose "with a footer section". You should now see a group footer section on your report.
0
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
<No Points wanted>

In Access 2007 open the report in design view and click "Group and Sort" on the Design Tab.
Select the Group you want, then click "More".
Locate the "Without Footer Section" setting, and change it to "WITH Footer Section"

;-)

JeffCoachman
untitled.JPG
0
 
Jeffrey CoachmanMIS LiasonCommented:
Sorry, late post anyway...
0
 
AccessYourBiz_ComCommented:
Yea Jeff mine was late too. I think Fyed nailed it. :-)
0
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.