How select query from record count more than 2 in MS Access

I'm trying to select query from row count more than 2 based on ID and DATE in MS Access.

Please Guide me

I want to keep it as a single query.

Thanks

Table Absen

Table MASTERID

I used this SQL code result like this:

select a.ID, MASTERID.NAMEID, a.DATE, a.TIME, a.INOUT
from ABSEN a INNER JOIN MASTERID ON a.ID = MASTERID.ID
where exists(select 1 from ABSEN a2 where a.ID=a2.ID)
order by a.ID, a.DATE

Result From code

Desired output

Try a GROUP BY subquery in the WHERE clause to get the ID's having at least one count per day > 2.

select a.ID, MASTERID.NAMEID, a.DATE, a.TIME, a.INOUT
from ABSEN a INNER JOIN MASTERID ON a.ID = MASTERID.ID
where a.id IN (select ID
               from ABSEN
               group by ID, date
               having count(*) > 2)
order by a.ID, a.DATE