I Need to run the last query listed below. I keep getting other data not needed in the query results. The first 4 queries ran correctly and the last 2 did not. I played around with the location of the data needed in the criteria field and the or fields below with no good results. There are two tables joined but the queries for the criteria is only in one table. Any help would be great.


Q1 This works correctly
LW 66 Students



SELECT StudentData.CurrentSem, StudentMedical.Race, StudentData.StudentID, StudentData.NameFirst, StudentData.NameLast, StudentData.[3LW], StudentData.[3OL], StudentData.[3AC], StudentData.[3BG], StudentData.[3EW], Int(DateDiff("d",[DoB],Now())/365.25) AS Age, StudentMedical.[Male/Female], StudentData.TransitionYN
FROM StudentData INNER JOIN StudentMedical ON StudentData.StudentID = StudentMedical.StudentID
WHERE (((StudentData.CurrentSem)="Semester 3") AND ((StudentData.[3LW])=Yes) AND ((StudentData.[Acitve?])=Yes))
ORDER BY StudentMedical.Race;

Q2 This works correctly
OL28 Students

SELECT StudentData.CurrentSem, StudentMedical.Race, StudentData.StudentID, StudentData.NameFirst, StudentData.NameLast, StudentData.[3LW], StudentData.[3OL], StudentData.[3AC], StudentData.[3BG], StudentData.[3EW], Int(DateDiff("d",[DoB],Now())/365.25) AS Age, StudentMedical.[Male/Female], StudentData.TransitionYN
FROM StudentData INNER JOIN StudentMedical ON StudentData.StudentID = StudentMedical.StudentID
WHERE (((StudentData.CurrentSem)="Semester 3") AND ((StudentData.[3OL])=Yes) AND ((StudentData.[Acitve?])=Yes))
ORDER BY StudentMedical.Race;

Q3 This works correctly
AC29 Students

SELECT StudentData.CurrentSem, StudentMedical.Race, StudentData.StudentID, StudentData.NameFirst, StudentData.NameLast, StudentData.[3LW], StudentData.[3OL], StudentData.[3AC], StudentData.[3BG], StudentData.[3EW], Int(DateDiff("d",[DoB],Now())/365.25) AS Age, StudentMedical.[Male/Female], StudentData.TransitionYN
FROM StudentData INNER JOIN StudentMedical ON StudentData.StudentID = StudentMedical.StudentID
WHERE (((StudentData.CurrentSem)="Semester 3") AND ((StudentData.[3AC])=Yes) AND ((StudentData.[Acitve?])=Yes))
ORDER BY StudentMedical.Race;

Q1 and Q3 Combined This works correctly
95 Students Listed

SELECT StudentData.CurrentSem, StudentMedical.Race, StudentData.StudentID, StudentData.NameFirst, StudentData.NameLast, StudentData.[3LW], StudentData.[3OL], StudentData.[3AC], StudentData.[3BG], StudentData.[3EW], Int(DateDiff("d",[DoB],Now())/365.25) AS Age, StudentMedical.[Male/Female], StudentData.TransitionYN
FROM StudentData INNER JOIN StudentMedical ON StudentData.StudentID = StudentMedical.StudentID
WHERE (((StudentData.CurrentSem)="Semester 3") AND ((StudentData.[3LW])=Yes) AND ((StudentData.[Acitve?])=Yes)) OR (((StudentData.[3AC])=Yes))
ORDER BY StudentMedical.Race;


Q2 and Q3 Combined This works correctly
57 Students Listed

SELECT StudentData.CurrentSem, StudentMedical.Race, StudentData.StudentID, StudentData.NameFirst, StudentData.NameLast, StudentData.[3LW], StudentData.[3OL], StudentData.[3AC], StudentData.[3BG], StudentData.[3EW], Int(DateDiff("d",[DoB],Now())/365.25) AS Age, StudentMedical.[Male/Female], StudentData.TransitionYN
FROM StudentData INNER JOIN StudentMedical ON StudentData.StudentID = StudentMedical.StudentID
WHERE (((StudentData.CurrentSem)="Semester 3") AND ((StudentData.[3OL])=Yes) AND ((StudentData.[Acitve?])=Yes)) OR (((StudentData.[3AC])=Yes))
ORDER BY StudentMedical.Race;

Q1 and Q2 Combined NOT WORKING Datasheet View show semester 2, 3 and s 4 students
Got 127 Students Listed Should be 94 Students

SELECT StudentData.CurrentSem, StudentMedical.Race, StudentData.StudentID, StudentData.NameFirst, StudentData.NameLast, StudentData.[3LW], StudentData.[3OL], StudentData.[3AC], StudentData.[3BG], StudentData.[3EW], Int(DateDiff("d",[DoB],Now())/365.25) AS Age, StudentMedical.[Male/Female], StudentData.TransitionYN
FROM StudentData INNER JOIN StudentMedical ON StudentData.StudentID = StudentMedical.StudentID
WHERE (((StudentData.CurrentSem)="Semester 3") AND ((StudentData.[3LW])=Yes) AND ((StudentData.[Acitve?])=Yes)) OR (((StudentData.[3OL])=Yes))
ORDER BY StudentMedical.Race;


Q1 and Q2 and Q3 Combined NOT WORKING Datasheet View show semester 3 and semester 4 students
Got 156 Should be 123 Students

SELECT StudentData.CurrentSem, StudentMedical.Race, StudentData.StudentID, StudentData.NameFirst, StudentData.NameLast, StudentData.[3LW], StudentData.[3OL], StudentData.[3AC], StudentData.[3BG], StudentData.[3EW], Int(DateDiff("d",[DoB],Now())/365.25) AS Age, StudentMedical.[Male/Female], StudentData.TransitionYN
FROM StudentData INNER JOIN StudentMedical ON StudentData.StudentID = StudentMedical.StudentID
WHERE (((StudentData.CurrentSem)="Semester 3") AND ((StudentData.[3LW])=Yes) AND ((StudentData.[Acitve?])=Yes)) OR (((StudentData.[3OL])=Yes)) OR (((StudentData.[3AC])=Yes))
ORDER BY StudentMedical.Race;