Grouping & sort in report wizard

[Hugh self taught]

Hi,

Can anyone offer an explanation why when creating a report from a table
using the wizard it automatically assigns a field as a group & the same group
is subsequently not available for a sort criteria. While in wizard mode the
group automatically selected by the wizard cannot be un-selected.

I'm just starting to get into reports in access & need a few pointers

 

[Marshall Barton]

Can anyone offer an explanation why when creating a report from a table
using the wizard it automatically assigns a field as a group & the same group
is subsequently not available for a sort criteria. While in wizard mode the
group automatically selected by the wizard cannot be un-selected.

The wizards are to a large degree pretty dumb. They are
intended for people that have never done it before and as a
quick way to get a bunch of design started. As soon as you
run into something a wizard does not do the way you want,
it's time to move away from the wizard and go into design
view. In design view you can do, or adjust what the wizard
did, pretty much however you want it.

In the Sorting and Grouping window (View menu), you can
select an entry by clicking at the left of the row. Once
selected, you can hit the Delete key to remove the selected
entery, hit the Insert key to create a new entry above the
selected entry, or even drag the selected entry to a
different position in the list.

 

[Duane Hookom]

If you select a field for grouping, it will automatically be sorted by the
field. I have been able to select and unselect a field in the "Grouping" step
of the wizard.

I rarely use the wizard for creating any report. I prefer to just layout the
report the way I want from scratch. I suppose the result of the wizard might
look better if I used lookup fields and set captions on my fields (none of
which I do).