Changing Sort on Report

[Don]

I have an Access 97 application and want to have a report sort by input from
my report manager screen. In my report I'm already grouping by one field.
How do I code to set up a second criteria in the grouping & sorting section
to handle this. I thought I could just sort the SQL being based in, but the
group by seems to change that sort.

Thanks

Don

 

[Allen Browne]

Add a 2nd row to your Grouping And Sorting dialog.
You can then assign the ControlSource of the GroupLevel at runtime to change
the sorting.

Details:
http://allenbrowne.com/ser-33.html