Use the Record sorting dialog box to set the criteria for sorting the records in the report.
When you sort, the program asks you to define two things: the sort direction (ascending or descending), and the field you want the sort to be based on (sort field).
Sort fields, such as Date, Time, and Currency, let you determine the order in which data appears on your report. Almost any field can be used as a sort field, including formula fields. A field's data type determines how the data from that field is sorted.