Hello there,
The below steps might help you out:
-Click the “Insert" menu and select "Group" to open the Insert Group dialog box.
-Select the desired field from the first drop-down list of the dialog box that appears on the screen. For example, to group your report by customer region, select “Region” from the drop-down list.
-Select how you want the group sorted within the report from the options available under the second drop-down menu. For example, select “In ascending order” to sort the group alphabetically in ascending order.
-Click “OK.” The dialog box closes and returns you to the Design view of your report.
-Click “Preview” to view the report.
Hope this resolves your Query !!
--If the reply is helpful, please Upvote and Accept it as an answer--