Group Header

Here you can choose to make a separate header in your report for this specific group, just like in the Categories report of the Northwind sample database.

Group Footer

Can be used alone or with the Group Header. You can place a footer under the grouping and add an object.

Group On

Allows you to organize your group based on each value of the group. For example, if left as the default “Each Value” there will be a grouping applied based on each entry in the group. For our cities example, this means that there will be a grouping for each city name, like London.

The Group On combo box contents change depending on the data type used to create the group. For example, if you were to group based on a Date/Time data type, you can “group on” using the Week.

Group Interval

Allows you to adjust the interval on how data is grouped. For example, if you want to apply a group based on a Date/Time data type, and the Group On setting is set to Week, you can enter the number 2 to group your data based on biweekly intervals.

Keep Together

This property changes depending on if you are applying to the section of the report or the entire group as a whole.

If you are applying to a section, Access will keep the information contained in a group together on the same page. This prevents data from printing across two pages.

If you are applying to an entire group, Access will make sure the entire group stays together on the same page, including the group header, detail, and footer.