Sort order in subform

[Guest]

I have a complex subform with the following record source:
SELECT DISTINCTROW Classes.ClassName, Departments.DepartmentName,
Instructors.Instructor, Classes.ClassID, [Employee Subform
Subquery].EmployeeID, [Employee Subform Subquery].Grade, [Employee Subform
Subquery].[Employees And Classes].DateCompleted FROM (Departments RIGHT JOIN
(Instructors RIGHT JOIN Classes ON
Instructors.InstructorID=Classes.InstructorID) ON
Departments.DepartmentID=Classes.DepartmentID) INNER JOIN [Employee Subform
Subquery] ON Classes.ClassID=[Employee Subform Subquery].ClassID;

I want to sort the subform by "DateCompleted" in desending order..
I tried "ClassID, DESC ORDER BY[DateCompleted];"
but that didn't work.
Any suggestions would be appreciated.

 

[Allen Browne]

The DESC goes after the field name:

ORDER BY DateCompleted DESC;