Adding a group header in Access 2002

[Brucels]

Several months ago, John Spencer provided the following information on this
topic:

"You can add another section that will print once by adding a group header to
your report and adding one page of the formatted text to the group header.

Set the value for the group header to
=1
and don't repeat the header on subsequent pages."

I have successfully added a group header using the Sorting and Grouping
dialogue box, but I cannot see where to set the value for the group header or
how to keep it from repeating on subsequent pages. Can John or anyone else
provided that information?

Thanks,
Bruce

 

[Duane Hookom]

The value of the grouping section is the value under the Field/Expression in
the Sorting and Grouping dialog. The top expression in your case should be:
=1
Set the Group Header to Yes which will display the section and allow you to
set its properties.

 

[Brucels]

Thanks Duane, that worked! I did not understand that I had to add an
expression in the Sorting and Grouping dialogue box.

Bruce