Report based on query "loses" alphabetical sort.

[Guest]

I've got a report based on a query. The query is sorted first by last name,
then by first name. Why won't my report retain this sort of sort?

 

[Douglas J. Steele]

Reports almost always ignore the order of records in their recordsource.

You need to specify the sort order in the report's Sorting and Grouping
dialog.

 

[david epsom dot com dot au]

or in the report's 'order by' property

"Note When a new object is created, it inherits the RecordSource, Filter,
OrderBy, and OrderByOn properties of the table or query it was created from.
"

But after that its not kept synchronised.

(david)