Morning!
I am using an option group to sort report fields. It works great how i currently have it setup. I would like to add a specific descending order to my Case 5, how would i add that?:
With Me
Select Case Frame26.Value
Case 1
'code to order by the CompanyName field
.OrderBy = "ACD Calls"
Case 2
'code to order by the ContactName field
.OrderBy = "Avg ACD"
Case 3
'code to order by the City and CompanyName fields
.OrderBy = "Total ACW"
Case 4
'code to order by the City and CompanyName fields
.OrderBy = "AHT"
Case 5
'code to order by the City and CompanyName fields
.OrderBy = "AgentCPH"
End Select
.OrderByOn = True
End With