QUERY buat cek data attendance di face recognition yang ada di file tarikan extension MDB (versi compare sama db minova format tanggal nya )
User documentation
01/13/2025
SELECT Format(USERINFO.Badgenumber,"00000000") AS IDN, USERINFO.Name AS Name, Format(DateValue([CHECKTIME]),"yyyymmdd") AS Tanggal, Format(Min(IIf(UCase(CHECKINOUT.CHECKTYPE)='I',TimeValue(CHECKINOUT.CHECKTIME),Null)),"hhmm") AS Masuk, Format(Max(IIf(UCase(CHECKINOUT.CHECKTYPE)='O',TimeValue(CHECKINOUT.CHECKTIME),Null)),"hhmm") AS Keluar
FROM CHECKINOUT INNER JOIN USERINFO ON CHECKINOUT.USERID = USERINFO.USERID
WHERE DateValue([CHECKTIME]) >= #10/01/2024#
GROUP BY USERINFO.Badgenumber, DateValue([CHECKTIME]), USERINFO.Name
ORDER BY USERINFO.Badgenumber, DateValue([CHECKTIME]) DESC;