Okay, I understand what you're saying - I'm just unsure of the specifics.
The database I'm in the process of designing is for the free tutorial program at the college I work for. When a student comes in and requests a tutor, we enter their information into the database; we also maintain information for the tutors. Most importantly, we keep track of the number and length of sessions through the database.
I'm designing several reports to view some basic information for all of the student learners based on criteria. I have a report for students who requested tutoring, then later dropped the course. I'd like to be able to view that report based on the semester. So, my database user clicks the button that says "Students Who Dropped Course" -- then that Option Group comes up and allows them to select the semester (Fall, Spring, Summer).
What needs to happen is the query criteria for the record's "Semester" field is whatever the user selected from that form with the Option Group. Then, the report gets its information from that query.
The semester information is housed in a Semesters table, and each semester has a code (i.e. Fall = 1, Spring =2, Summer = 3). So in my Option Group, the option value would be "1" for Fall, etc. However, I'm not sure what I would type into the criteria line in the query.
Thanks for your help!