How select query from record count more than 1 and count more than 2 with custom column (Option) in MS Access

I'm trying to select query from record count more than 1 (ID&DATE&INOUT) and count more than 2 (ID&DATE) with custom column (Option) in MS Access

so with "NO" in the option column then the record more than 1 and more than 2 is not included in my sql query code

example for ID 5045 Date 12-Jul-24 should only appear 3 records because they have been marked in the option column NO

Is there something wrong with my SQL code ?

Please Guide me

Table Absen for testing

Table MASTERID

with Code Answer update

SELECT a.ID, MASTERID.NAMEID, a.DATE, a.TIME, a.INOUT
FROM ABSEN AS a INNER JOIN MASTERID ON a.ID = MASTERID.ID
WHERE (SELECT COUNT(*)
       FROM ABSEN AS a2
       WHERE a.ID = a2.ID 
         and a.DATE = a2.DATE and a.INOUT = a2.INOUT
         and IIF(a2.OPTION IS NULL, '', a2.OPTION) <> 'NO'
       ) > 1 OR  (SELECT COUNT(*)
       FROM ABSEN AS a2
       WHERE a.ID = a2.ID 
         and a.DATE = a2.DATE
         and IIF(a2.OPTION IS NULL, '', a2.OPTION) <> 'NO'
       ) > 2 
ORDER BY a.ID, a.DATE, a.INOUT;

Result From code

Desired Result

You can exclude those directly, not based in count:

SELECT a.ID, MASTERID.NAMEID, a.DATE, a.TIME, a.INOUT
FROM ABSEN AS a INNER JOIN MASTERID ON a.ID = MASTERID.ID
WHERE ((SELECT COUNT(*)
       FROM ABSEN AS a2
       WHERE a.ID = a2.ID 
         and a.DATE = a2.DATE and a.INOUT = a2.INOUT
         and IIF(a2.OPTION IS NULL, '', a2.OPTION) <> 'NO'
       ) > 1 OR  (SELECT COUNT(*)
       FROM ABSEN AS a2
       WHERE a.ID = a2.ID 
         and a.DATE = a2.DATE
         and IIF(a2.OPTION IS NULL, '', a2.OPTION) <> 'NO'
       ) > 2 )
AND IIF(a.OPTION IS NULL, '', a.OPTION) <> 'NO'