SELECT NStudTT.Student, NStudTT.Day, NStudTT.Lesson, NStudTT.Subject, Q.DateTime, Q.Subject, Q.Teacher, 
	Q.Destination, Q.Lesson, NStudTT.StudentID
FROM 
(
	SELECT 
		Movement.DateTime, Movement.StudentID, Movement.Subject, Movement.Teacher, Movement.Destination, Movement.Lesson
	FROM 
		Movement
	WHERE (((Movement.DateTime) Between #6/15/2007 7:0:0# And #6/15/2007 19:0:0#) AND ((Movement.Destination)="Away" Or 
		(Movement.Destination)="sign out" Or (Movement.Destination)="sign in") AND ((Movement.Lesson)=3)) OR 
		(((Movement.DateTime) Between #6/15/2007 7:0:0# And #6/15/2007 19:0:0#) AND ((Movement.Destination)="sign in"));
) Q
		RIGHT JOIN NStudTT ON Q.StudentID=NStudTT.StudentID
WHERE 
	(((NStudTT.Day)=5) AND ((NStudTT.Lesson)=3) AND ((NStudTT.Subject) Like "stu*"));