duplicates by date

[jmwings]

I have an Access database of student class absences.
I need to find students who were absent for more than 4 classes a day.


I'm struggling to find a way to get duplicates of students > 4 broken down by day. When I do a query > 4 on Student ID, this returns duplicates of my students over all of the days. I need to group by date first, and then find students > 4 for that day.
Table columns are StudentID, StudentName, and Date.
Can anyone help?

[mike60smart]

Hi

We would need more than the information you have given.

How are you recording the Classes for each Student?

Best to upload a zipped copy of the database.

[Micron]

Agreed. Not clear if Date is null if they attended and not null if they were absent, or what. Also, Date is a reserved word and should not be used for any object. In fact, IMO of all the reserved words it's about the worst one you can use yet it's so often done.

[CJ_London]

your table does not make sense - you have a StudentID and a StudentName. I would expect to only see StudentID (as a foreign key) and the name in a separate table of students with StudentID as a primary key. And as Mike says - would also expect to see a classID in the table.

Suggest provide some example data and the expected outcome from that data.