Set or change the default sort order of records on a data access page

1. Open the data access page in Design view.
   
   
2. Click Sorting And Grouping on the toolbar to display the Sorting And Grouping box.
   
   
3. Click the group record source for which you want to set the sort order.
   
   
4. In the DefaultSort property box, type the name(s) of the field(s) you want to sort on. Separate the names with a comma. You can follow each name with a space and the keyword ASC or DESC. For example, type OrderDate DESC, OrderID ASC. If you don't specify the order, Microsoft Access sorts in ascending order.

   Note   If the control you want to sort on is bound to an expression, you must type the alias of the control as displayed in its ControlSource property. For example, if the ControlSource property of the control you want to sort on is set to GroupOfExtendedPrice: ExtendedPrice, type GroupOfExtendedPrice in the DefaultSort property.