How to "ORDER BY" in descending order?

[Richard Hollenbeck]

I have the following query in a combo box:

SELECT courses.courseCode, courses.courseDescription FROM courses ORDER BY
courseDescription;

I want to change the "ORDER BY" to display in descending order so the more
recent courses appear first on the list. How do I modify this query to
accomplish that end?

Thanks!

Rich Hollenbeck
Moreno Valley, CA USA

[Allen Browne]

Use DESC in the ORDER BY clause for a descending sort.

Assuming you have a CourseDate field so you can determine "more recent":
SELECT courses.courseCode, courses.courseDescription
FROM courses
ORDER BY CourseDate DESC, courseDescription;

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Richard Hollenbeck" <ri****************@verizon.netwrote in message
news:6W9eh.782$qh.171@trnddc06...

>I have the following query in a combo box:

SELECT courses.courseCode, courses.courseDescription FROM courses ORDER
BY courseDescription;

I want to change the "ORDER BY" to display in descending order so the more
recent courses appear first on the list. How do I modify this query to
accomplish that end?

Thanks!

Rich Hollenbeck
Moreno Valley, CA USA

[Richard Hollenbeck]

Use DESC in the ORDER BY clause for a descending sort.

Yes that did it. This is such a nice trick that I'm rewriting all my code,
wherever necessary, to include it.

Thank you very much!