G
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.
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.