create an unmatched query based on the date

[EileenJohn]

Hi, I'm still new to Microsoft access. I'm trying to create a database monitor students attendance. I have 2 sheet.
Sheet 1 (keep the student list): student id, student name, address class name
sheet 2 (keep the student attendance record): date, student id, student,name, class name
I try to create a query to "find no. of students that did not attend the class based on the date".
I did try to create a query using unmatched wizard but it didn't give me the result that I want.
Any ideas? Thanks in advance.

 

[Joe4]

I am sorry, but I keep feeling that I only have "pieces" of the problem, but not the big picture on how it all goes together (for example, you just introduced "batch" which was not part of the original problem. It kind of feels like things are all over the place and keep shifting/changing.

One of things I am confused about is the WeeklyAttendance table. Is there just one class a week? If not, and people can show up on that list more than once, what exactly are you looking for in your results? A break-down by day? Or if it is over multiple weeks, what does that data look like? The Date in the WeeklyAttendance table probably wouldn't match the date in the Register table, would it?