I am making a grade entering system in Access, and I am running into some issues with a query.
One of my queries gets the class roster of a class. It takes in the students information, and then it also displays a grade next to their name. For the grade entry system, I only want to have students that do not have a grade already entered to appear.
To do this, in my
Grade field, I have tried to set the
This is not working as it just does not display any student at all. The weird thing is, whenever I set it to
Is Not Null, it shows me all of the students that have grades entered, and ignores all the students without a grade like I would expect.
So, since the students without grades are left out when the
Criteria is set to
Is Not Null, that leads me to believe that a student without a grade is
So, I am very confused why setting the
Is Null, just leaves me with no results.
I am very new to Access, so if there is some important information I need to provide for adequate help, please let me know!