If
you've grouped report records by a specific field (for
example, by the State field), having the report repeat the
same State data for each record in a group makes it hard to
read and distinguish between groups. You can make Access
display the State data only once per group. Follow these
steps:
-
Open
the report in Design View.
-
Right-click the State field, and select Properties.
-
On
the Format tab, set the Hide Duplicates property to Yes.
When you
run the report, Access will display only the first instance
of each value for the State field in a group.
