hide fields from being previewed by a specified report

[chris17]

Please i have report that i want to filter failed courses but i want the failed courses to be hidden when passed by the student. I dont want the course failed to removed because it ll be used some other place but want to hide it in the failed course report if passed. Thanks as i expect your help.

[June7]

Apply filter to report so those records are excluded.

[chris17]

Please I don't really understand.

[chris17]

The picture contains an illustration of what i am trying to explain.

[June7]

I don't know your data structure so can only offer generalities. Try someting like:

Query1
SELECT StudentID, CourseID, Grade FROM StudentCoursesGrades GROUP BY StudentID, CourseID, Grade HAVING Grade <> "F";

Then join Query1 to StudentCoursesGrades table:
SELECT StudentCourseGrade.ID, StudentCourseGrade.StudentID, StudentCourseGrade.CourseID, StudentCourseGrade.Grade
FROM Query1 RIGHT JOIN StudentCourseGrade ON (Query1.StudentID = StudentCourseGrade.StudentID) AND (Query1.CourseID = StudentCourseGrade.CourseID)
WHERE (((Query1.Grade) Is Null));

Or as nested subquery:
SELECT StudentCourseGrade.ID, StudentCourseGrade.StudentID, StudentCourseGrade.CourseID, StudentCourseGrade.Grade
FROM (SELECT StudentID, CourseID, Grade FROM StudentCoursesGrades GROUP BY StudentID, CourseID, Grade HAVING Grade <> "F") As Query1 RIGHT JOIN StudentCourseGrade ON (Query1.StudentID = StudentCourseGrade.StudentID) AND (Query1.CourseID = StudentCourseGrade.CourseID)
WHERE (((Query1.Grade) Is Null));

Or use DLookup instead:
SELECT StudentCourseGrade.ID, StudentCourseGrade.StudentID, StudentCourseGrade.CourseID, StudentCourseGrade.Grade, DLookUp("Grade","StudentCourseGrade","StudentID=" & [StudentID] & " AND CourseID=" & [CourseID] & " AND Grade<>'F'") AS NonFGrade
FROM StudentCourseGrade
WHERE (((DLookUp("Grade","StudentCourseGrade","StudentID =" & [StudentID] & " AND CourseID=" & [CourseID] & " AND Grade<>'F'")) Is Null));