Query lacks Specific Criteria

[MotoTraining]

I am trying to build a query that retrieves record for any student who has
not attended our college in the last 6 semesters. Currently, there is a
student table linked to a semester table. Everytime a student enrolls in a
semester, a new link is created. I built a query that retrieves the students
who were in (semester 7), but naturally, some of these students are also in
semesters 1-6. How can I eliminate records from coming up in the query who
are in semesters 1-6?

 

[strive4peace]

you should have table structures similar to the following:

Students
- StudentID, autonumber
- SchoolID, text -- in case you assign IDs to your students
- Stud_Lastname
- Stud_firstname
etc

each Student is only in the Student table ONE time

Semesters
- SemesterID, autonumber
- StartDate, date
- EndDate, date
- SemesterName, text
- SemesterNum, integer

StudentSemesters
- StudSemID, autonumber
- StudentID, long, fk to Students
- SemesterID, long, fk to Semesters

~~~

I get the feeling, though, that you have multiple Students in the
Students table ... each time they are enrolled for a Semester ...

we can answer your question with unnormalized data, but it would be
better for you to normalize the data. We can help you convert what you
have to a normalized structure if you specify a bit more about your
current structure ... then answer your question


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm

*
have an awesome day
*