Sort Report Button

[SantasLittleHelper]

I have a report based on a Query and I'd like a button on the report to switch between the Sorts below:

1. Sort by [Name] A-Z THEN [Date] Oldest to Newest
2. Sort by [Date] Oldest to Newest THEN [Name] A-Z

I'm guessing code is the easiest way but I'm unsure how to do this one.

 

[welshgasman]

Have a look here.

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