Order by in Reports 1

[ronphx]

I have an invoice report (rptinvoice) that prints from a query (qryinvoice). The query specifies invoice lines from a table and is sorted by an invoice line order (called ordr). When I print the invoice (rptinvoice) from the query, the invoice is printed in the natural table order (unsorted), even though when I run the query it displays the invoice lines in correct sorted order. When I specify "Order By" as field ordr in the report and "Order By On" as YES in the report it prints out in the correct order.

My question is: Does the report ignore the sort order specified in the query?

 

[RoyVidar]

Reports question, forum703?

In my opinion, the only reliable sort in reports, is with the sorting/grouping thingie within the report. I don't thinkg the order by clause of queries/reports are reliable.

So - yes - the report usually ignores the sort order of queries.

Roy-Vidar

 

[ronphx]

Thanks for the reply. I agree with you that the sorting/grouping option is a better way to go. It is strange that the query sorting option is ignored.

(I realized after I sent the question that I should have sent it to the Access Reports Forum. Thanks for answering the question anyway).