Hello.
I am trying to generate a report that identifies a row only once. However, I suspect that I am using the DISTINCTROW incorrectly.
Any clues with this would be greatly appreciated.
SELECT DISTINCTROW EdwaaDepartment.[EDWAAA(1,2,3,4,5,6,7)], MainDepartment.SID, Students.[Last Name], Students.[First Name], StudentStatus.[Work Status], StudentProgramIntersection.[Grad Qtr/Yr], Students.[Phone (Day)], MainDepartment.Boeing, MainDepartment.DescriptionNotes, MainDepartment.Workforce, StudentProgramIntersection.Program
FROM (Students INNER JOIN ((StudentStatus INNER JOIN MainDepartment ON StudentStatus.[Work Status] = MainDepartment.[Work Status]) INNER JOIN EdwaaDepartment ON MainDepartment.DepartmentID = EdwaaDepartment.DepartmentID) ON Students.SID = MainDepartment.SID) INNER JOIN StudentProgramIntersection ON Students.SID = StudentProgramIntersection.SID
WHERE (((EdwaaDepartment.[EDWAAA(1,2,3,4,5,6,7)])=7) AND ((StudentProgramIntersection.[Grad Qtr/Yr])="Sum 2001"));
Thank you.
I am trying to generate a report that identifies a row only once. However, I suspect that I am using the DISTINCTROW incorrectly.
Any clues with this would be greatly appreciated.
SELECT DISTINCTROW EdwaaDepartment.[EDWAAA(1,2,3,4,5,6,7)], MainDepartment.SID, Students.[Last Name], Students.[First Name], StudentStatus.[Work Status], StudentProgramIntersection.[Grad Qtr/Yr], Students.[Phone (Day)], MainDepartment.Boeing, MainDepartment.DescriptionNotes, MainDepartment.Workforce, StudentProgramIntersection.Program
FROM (Students INNER JOIN ((StudentStatus INNER JOIN MainDepartment ON StudentStatus.[Work Status] = MainDepartment.[Work Status]) INNER JOIN EdwaaDepartment ON MainDepartment.DepartmentID = EdwaaDepartment.DepartmentID) ON Students.SID = MainDepartment.SID) INNER JOIN StudentProgramIntersection ON Students.SID = StudentProgramIntersection.SID
WHERE (((EdwaaDepartment.[EDWAAA(1,2,3,4,5,6,7)])=7) AND ((StudentProgramIntersection.[Grad Qtr/Yr])="Sum 2001"));
Thank you.
