Query sorts correctly, report does not

[Guest]

I have a report that is driven by a query. The query has ORDER BY statements
so that it sorts correctly, and it works fine. However, the report does not
seem to be sorting at to my eye, certainly not by the same as criteria as the
query. The report's "order by" property is blank, and the "order by on" field
is set to No. Any idea why the report would choose to sort differently than
the query?

Thanks,
Graham

 

[fredg]

The sort order in your query is irrelevant to the sort order of your report.

To sort your report, use the report's Sorting and Grouping dialog....
In Design View click on View + Sorting and Grouping.

Fred

 

[Guest]

A report disregards sorts in a query.
Use the report Grouping and Sorting.

 

[Guest]

Oh yeah, right. Duh. I feel stupid now! I totally forgot about the sorting
and grouping! Thanks for the reminder fredg and Karl.

 

[Linda]

It pays to look through the old messages - I didn't know this, either!! I
was using the sorting and grouping in reports, but a simple change in order
fixed my report. I thought for sure it got the sorting orders from the query.
Thanks!

Linda