How can I change the sort order on report.

[Guest]

In Access 2000 I have a report which lists a number of companies and orders
sorted by CompanyName. The sorting is set in the Sorting and Grouping dialog
form, as normal. I want to be able to have the option of sorting the list on
the OrderValue field, preferably by ticking a Check box before I print the
report. Is there any way of programmatically changing the settings of the
Sorting and Grouping form. I don't want to do this in the report's query
because there are also Group Headers and Footers on the report.

 

[Allen Browne]

Sure. Set the ControlSource of the GroupLevel

Example in:
Sorting report records at runtime
at:
http://allenbrowne.com/ser-33.html

 

[Guest]

ati Allen

Thanks very much for the info, I will try it out tomorrow. I seem to learn
something new about Access every day.