Sort Parameter

[Karin]

Can you create a parameter to allow the user to choose whether to sort by
date or by client name? Report runs from a query.

 

[Duane Hookom]

Allen Browne has code to set sorting at runtime at
http://www.allenbrowne.com/ser-33.html

 

[Karin]

Thank you for your response, but this does not seem to set a changeable
parameter but to be hard coded (unless I'm misunderstanding something).

 

[Duane Hookom]

The sorting depends on the selection made by a user in the option group:
Forms!frmChooseSort!grpSort
You would need to have some method for your users to make a selection. In
the example, this was done through a form named "frmChooseSort" and an option
group named "grpSort". You would need to use your own form and control.

Your code would need to be modified based on your fields and controls.