Adjust grouping levels programmatically

[Guest]

Greetings,

I'm trying to adjust grouping levels of a report based upon user input from
the Open Report event. Specifically, I'd like to give my users the option to
specify additional grouping levels above and beyond the basic report default.
The report in question pulls its data from a select query with all the
heavy lifting (calculations & sorts) pre-set.

I'm trying to offer my users the following grouping options:

1. Team, Billing Code (default)
2. Team, Account Executive, Billing Code
3. Team, Account Executive, Campaign Phase, Billing Code

The basic report design incorporates a Billing Code Group Header & Footer,
but I'd like (or rather my boss & co-workers are clamoring for) additional
flexibility with the output. Don't have any problems prompting my users for
input, but can't for the life of me figure out just exactly *how* to get the
message across to Access to make the appropriate adjustments and group the
report accordingly. It's a bloody simple Select Case statement; but the
precise syntax for the additional grouping levels is driving me nuts!

Unfortunately I'm not at work right now or I would post my code for
everybody's continued comic relief. So how 'bout it? Any help out there for
a frustrated data analyst?

 

[Guest]

Allen Browne has code to do this on his web site at
http://www.allenbrowne.com/ser-33.html.

 

[Guest]

Whoop there it is! I *knew* it was something *simple* being overlooked!

Thanks!