Microsoft Access Reports – The Report in Design View

Report Sort Order 

On the Design Ribbon Clck on the Group and Sort Button in the Grouping and Total section .  This displays the bar at the bottom where  you can set the grouping and sorting setttings by clicking on the dropdown arrows and then selecting the options required.