Report Grouping

  • Thread starter Thread starter HBS
  • Start date Start date
H

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
 
HBS said:
Using Access 2000... is there a limit to the number of grouping/sorting that
affect the report?
Click to expand...

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.
Click to expand...

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.
 
Back
Top