Call records not showing attendance date

[bretdunlap]

Hi
If you all could suggest some ideas

I have 2 tables (student Info) and (student attendance)and a form called (DNS (did not show)) basically in the student attendance I record the dates that a student attended class.

What I am trying to figure out it the sql query or VBA to call the records that are not associated with dates from the attendance table between and including 2 dates.

For example: on My form I have 2 txt boxes that I place in Mondays date and say Weds date I need to see who hasn't been recorded for attendance between and including the dates in the range.

IE who doesn't have at least 7/18 7/19 7/20 but I could also chose the first and the 30th of any month so I need a formula referring to the 2 boxes.

[pod]

you might have to reformat the syntax but I believe it would give you what I think you want, and that all depends on how you record everything in the [student attendance] table

select * 
from [student Info] 
where studentID not in 
      (
          select distinct studentID 
          from [student attendance] 
          where attendancedate in between #datestart# and #dateend#
       )