grouping

[rob p]

I have a report that groups by division number. (division 10, 20, 30, 40,
50, etc.) This field / column in in a query.

How can I make the report group division 10, then group the combined
divisions 20 and 30, then group at division 40, etc...
Group 20 and 30 would have only one footer / total.

Thanks.

 

[Gary Miller]

One way would be to create another field in your divisions
table that would specify the GroupingLevel and actually
group your report by that field instead.

Division GroupLevel
10 1
20 2
30 2
40 3

Gary Miller