Earth | North America | United States | California | Long Beach
The way that I have implemented this is with a form that serves as a report request form.
One of the parameters on the form is the sort order of the report. I happened to utilize a combo box (so that I could add additional sort selections later, if needed) but it could be done with a button.
If you are asking to change the sort order while viewing the report...that is above my head. I am not sure how you would do that.
try to make a comboBox on your form having the diffrent sort order, then on your Report_Open event make a SELECT statement including all possiblites of te ComboBox.
Also don't forget to enable the OrderBy of the Report
i.e Me.OrderByOn = True
Select Case Forms!CoboBoxName.ListIndex
Me.OrderBy = "[TableName]![anyFieldInTable],