no sort on group header

[Guest]

I have a report that has a group header that has a combo box which has a
control source of a clinicianID. The row source of the box places first name
and last name with the bound column being the id. The sorting and grouping
sorts on the id asc but the user wants it to sort on last name. Is it
possible to have a group header without a sort? I have put an order by
[last_name] on the row source query but the sorting and grouping overrides
this. Any wisdom would be appreciated. Thanks.

 

[Rick B]

Why not just put the "last name" in your grouping and sorting?