Sort works in query not report

[Guest]

I have a query that is sorted on a date in decending order. When I run the
query, it sorts correctly. This query is the record source for a report. When
I run the report, the sort is not working. What have I missed. I do not have
the properties set for Order By in the list for the report. It should just be
feeding from the order by clause in query.

Thanks
Kenny A.

 

[Douglas J. Steele]

The only way to ensure the order in a report is to use the Sorting and
Grouping dialog. The order of the data in the underlying recordsource is
irrelevant.

 

[Roger Carlson]

The Order By clause of the query has no effect on the sort order of the
Report. You *have* to set the order in the Report, so their is really no
need to set it in the Query.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

How do I set the the order in the report so the correct field is sorting in
decending order? Why is it setup so the order by in the query (which is the
record source for report) has no bearing on the out come of the report?

 

[Roger Carlson]

In the Design view of the Report, go to View > Sorting and Grouping. Select
the field you want to sort by and choose Descending.
As to why -- I don't know. That's just the way it is.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Thanks Roger. Two mins before you responded, I found where I needed to set up
the sort by. Thanks again