QUERY buat cek data attendance di face recognition yang ada di file tarikan extension MDB
User documentation
01/03/2025
SELECT USERINFO.Badgenumber AS IDN, USERINFO.Name AS Name, DateValue([CHECKTIME]) AS Tanggal, Min(IIf(UCase(CHECKINOUT.CHECKTYPE)='I',TimeValue(CHECKINOUT.CHECKTIME),Null)) AS Masuk, Max(IIf(UCase(CHECKINOUT.CHECKTYPE)='O',TimeValue(CHECKINOUT.CHECKTIME),Null)) AS Keluar
FROM CHECKINOUT INNER JOIN USERINFO ON CHECKINOUT.USERID = USERINFO.USERID
WHERE DateValue([CHECKTIME]) >= #6/15/2022#
GROUP BY USERINFO.Badgenumber, DateValue([CHECKTIME]), USERINFO.Name
ORDER BY USERINFO.Badgenumber, DateValue([CHECKTIME]) DESC;