I have am creating a roster that I would like to have show students names, course taken, and letter grade.
Each segment is it's own table: Students, Course and Grade.
What I am trying to connect is all three tables and show the records where the grade is not an F or withdrew. The problem is - is when add the the grade critiera it removes those individuals that have an F or withdrew but also those patients that do not have a grade as well. Is there any to keep the blanks with those that have an acceptable grade?