I have a form that sets query criteria then runs the query. The query is searching a gradebook for students who are missing assignments. The form asks for Student Name and Course.
- If I select the student, I would like it to return a list of all missing assignments for all courses for just the selected student.
- If I select Student and Course, I would like it to return a list of only those missing assignments for the selected course for the selected student.
- If I select just the course, I would like it to return the missing assignments for all students for the selected course.
I have been successful in setting the query criteria and getting each of the above to work by itself but I can't seem to get all three options together.
Thank you in advance!