Code

[NJBuckeye]

Hello,

I modified, or am trying to modify, the Classroom Management template on the Mcirosoft website. In one of the reports, I want the fields completed (check box, did they or did they not complete the course), and year (their field name, but it is really the date). The designer(s) used SQL instead of queries, and I'm below novice with SQL... I can do the most basic of things.

Can anyone tell me where the mistake is?

Thanks so much.

GA

SELECT DISTINCTROW
Classes.ClassID,
Classes.ClassName,
Classes.SectionNumber,
Classes.Units,
Classes.Location,
Classes.DaysAndTimes,
Students.StudentID,
Students.PhoneNumber,
Students.Organization,
Departments.DepartmentName,
Instructors.Instructor,
[Students And Classes].completed,
[Students And Classes].year,
[LastName] & ", " & [FirstName] AS [Student Name]


FROM
(Students INNER JOIN (((Instructors RIGHT JOIN (Departments RIGHT JOIN Classes ON Departments.DepartmentID=Classes.DepartmentID) ON Instructors.InstructorID=Classes.InstructorID)
INNER JOIN [Students And Classes] ON Classes.ClassID=[Students And Classes].ClassID)
INNER JOIN [Students And Classes] ON [Students And Classes].Completed = [Students And Classes].Completed)
INNER JOIN [Students And Classes] ON [Students And Classes].year = [Students And Classes].year)
INNER JOIN Assignments ON Classes.ClassID=Assignments.ClassID) ON Students.StudentID=[Students And Classes].StudentID)

GROUP BY Classes.ClassID, Classes.ClassName, Classes.SectionNumber. Classes.Units, Classes.Location, Classes.DaysAndTimes, Students.StudentID, Students.PhoneNumber, Students.Organization, Departments.DepartmentName, Instructors.Instructor, [LastName] & ", " & [FirstName], [Students And Classes].completed, [Students And Classes].year;