grouping/sorting limits

[AccessMan]

I have a need to have the maximum number of groups possible on a report (10),
but I want each grouping to be sorted by a field that is different than the
grouping field. Is there any way to add a sorting field to each of the 10
groups without deleting any groups? Not surprisingly, I was unsuccessful in
trying to apply the sorting in the query.

Thanks!

 

[KARL DEWEY]

Post sample data and what you want in results.

 

[AccessMan]

Karl:

I had been troubleshooting another minor issue when I posted my question,
and its solution involved moving the desired sorting field into the grouping
field (at the front). This solved both problems. Perhaps you are not
surprised to hear this.

Thanks!