Adding or changing a group variable in a report

[trekgoes2malaysia]

I created a report using the Reprot Wizard. During the process it
allows you to sleect the fields to group data by. Since having
created this report and spending some time formating it, I have
realized I need to add another grouping field to present the data as
intended. Unfortunately I cannot figure out how I can add a new a
grouping field to the report without having to start from scratch
using the wizard. Also, is switching a grouping field to another one
possible? Can any one provide suggestions??

Patrick

 

[Duane Hookom]

While in design view of the report, view the sorting and grouping dialog.
This allows you to add, delete, or change control sources for grouping
levels. You can also set which levels have headers/footers.

 

[Marshall Barton]

I created a report using the Reprot Wizard. During the process it
allows you to sleect the fields to group data by. Since having
created this report and spending some time formating it, I have
realized I need to add another grouping field to present the data as
intended. Unfortunately I cannot figure out how I can add a new a
grouping field to the report without having to start from scratch
using the wizard. Also, is switching a grouping field to another one
possible?

With your report open in design view, use the View menu to
open the Sorting and Grouping window. You should then be
able to see the list if groups and change it to suit your
needs.