Report Grouping

[HBS]

Using Access 2000... is there a limit to the number of grouping/sorting that
affect the report?

My inventory currently should grouping like:
Class, Fabric, Hue, Color, Group, Height,

And then further sort by:
Width, Letter

For some reason the grouping work, except "Group" which does not force a
section break.

Is there a clue I should be looking for?

Thanks, HBS

 

[Marshall Barton]

Using Access 2000... is there a limit to the number of grouping/sorting that
affect the report?

The limit is 10 levels of sorting and grouping,

My inventory currently should grouping like:
Class, Fabric, Hue, Color, Group, Height,

And then further sort by:
Width, Letter

For some reason the grouping work, except "Group" which does not force a
section break.

That's strange. The only thing I can think to try is to
change the name of the field (Group is part of an SQL
reserved word). While you're at it, you should change the
name of the Height, and Width fields too, both are Access
reserved words.