ordering of records in report

[jfp]

I have a report with data source a query.
When i run the query, the records appear in a certain order (sorted by
field, left to right, per the Select clause).
When i run the report, the records appear in a different order.
Now, i understand that there is no particular order for the records in a
table -- but does this also apply to the output of a query?
That is, am i viewing the query output the same way that the report sees
it -- or, do i have to explicitly place dummy groups (no header or
footer) in the report in order to force the order i expect ?

 

[Van T. Dinh]

Reports ignores the ordering in the RecordSource Query. You need to use the
Report's "Sorting and Grouping". Open the Report in DesignView and use the
Menu View / Sorting and Grouping ... Alternatively, use the "Sorting and
Grouping" icon just to the right of the ToolBox icon in the Report Design
Toolbar.