query dates that don't exist in the record

[Ravenray]

Here's the situation, I have two tables. 1) Clients and 2) Attendance. I'm trying to create a query to pull names that don't have an attendance record between certain dates. I had try the join types and it seems to not do it. Can this actually been done?

I did a testing of a weekend where there won't be any attendance and it should pull everyone's name, but it doesn't and I had change join types. Does anybody have a solution for this?

 

[WayneRyan]

Ravenray,

You can put together a query like this:

Select Student
From   StudentTable
Where  Student Not In (
   Select Student
   From   Attendance
   Where  AttendanceDate Between x and y)

Wayne

 

[Ravenray]

That work B-e-a-utiful. Thank you very much.