Order of records in a detail section 1

[irethedo]

What dictates the order of records displayed in a detail section of a report?

I have a report which has the data source of a query and
I specify in the query the order of the records in ascending order by a number field. When I run the query, the records are displayed in the correct order (#1 record on top of the list in my detail section with the last record displayed last) but when I run the report, the detail section displays record #2 on top followed with however many records I have, and record #1 is displayed at the bottom of the list.

How can I set this report up so that record #1 is on top?

Thanks

 

[Remou]

You can use Sorting and Grouping for the report, you will find it in Design View.

 

[irethedo]

Thanks Remou