Query Only If Failed To Meet Requirements

I am tyring to set up a query, that runs from a selected date range, to return only the records that don't meet the requirments. For example, I have four fields:

Name
Date
Attended
Required

I want to start the query from a date range usesing Between [StartDate] And [EndDate]. There are mulitpule records containing the same date. Then from there I want to return only the Names that don't attend the required number of sessions.

Ex.
Attended = 2; Required = 4; Return name
Attended = 3; Required = 3; Don't return name

Would this be possible with one query? If so, how would I go about setting up the criteria. If not then how would i link the 2 queries together?