I guess I could make different 'Heads' for each column that could be used for the sort. Really, I don't think it would be more than 3 or 4 different fields. I'm sure I know how to programmatically group and sort in the report opening (which is used for the print outs).

Guess I was just trying to be fancy...

[EDIT]

I take that back, it might not be all that easy (the report layout was made quite a while ago, so I had to go back and look at it).

Maybe the whole process I started is not the best... In any case, the report takes the Heads field for spacers between the groupings. I'm guessing I should take this back to an access forum, but just in case you all might have a suggestion, I'm guessing that I could take the output from the SQL and create a query that would use the sorting Header field as Heads. I could then do the Order By and Grouping before the report opens...