Hi all,
I have a complicated query with the following SQL
Code:
SELECT [FirstName] & " " & [FathersName] & " " & [GrandFatherName] & " " & [FamilyName] AS NameOfStudent, tblSchoolYears.SchoolYear, tlkpGrades.GradeLevel, tblGradeSection.GradeSection, tblStudents.PlaceOfBirth, tblStudents.BirthDate, tblStudents.IdentitiyCardNumber, tblDistricts.City, tblJoinStudentsYears.CurrentStudent
FROM tlkpGrades RIGHT JOIN ((tblGradeSection RIGHT JOIN (tblStudents LEFT JOIN (tblSchoolYears RIGHT JOIN tblJoinStudentsYears ON tblSchoolYears.pkSchoolYears = tblJoinStudentsYears.fkSchoolYears) ON tblStudents.pkIdNumber = tblJoinStudentsYears.fkStudentGrade) ON tblGradeSection.pkGradeSection = tblJoinStudentsYears.fkGradeSection) LEFT JOIN (tblDistricts RIGHT JOIN tblStudentAddresses ON tblDistricts.pkDistrictId = tblStudentAddresses.fkDistrictID) ON tblStudents.pkIdNumber = tblStudentAddresses.fkIDNumber) ON tlkpGrades.pkGrades = tblJoinStudentsYears.fkGrades
WHERE (((tblSchoolYears.SchoolYear) Like [Forms]![frmStudentsLists]![cboSchoolYear]) AND ((tlkpGrades.GradeLevel) Like [Forms]![frmStudentsLists]![cboGradeLevel]) AND ((tblGradeSection.GradeSection) Like [Forms]![frmStudentsLists]![cboGradeSection]) AND ((tblJoinStudentsYears.CurrentStudent)=True))
ORDER BY [FirstName] & " " & [FathersName] & " " & [GrandFatherName] & " " & [FamilyName];
Is it possible to edit CurrentStudent field?
Sincerely yours
Khalil