QUERY buat cek data attendance di face recognition yang ada di file tarikan extension MDB (versi compare sama db minova format tanggal nya ) tanpa pakai checktype I dan O
User documentation
06/19/2025
SELECT
Format(USERINFO.Badgenumber, "00000000") AS IDN,
Format(DateValue([CHECKTIME]), "yyyymmdd") AS Tanggal,
Format(Min(CHECKINOUT.CHECKTIME), "hhmm") AS masuk,
Format(Max(CHECKINOUT.CHECKTIME), "hhmm") AS keluar
FROM
CHECKINOUT
INNER JOIN
USERINFO ON CHECKINOUT.USERID = USERINFO.USERID
WHERE
DateValue([CHECKTIME]) >= #01/12/2024#
GROUP BY
USERINFO.Badgenumber, DateValue([CHECKTIME]), USERINFO.Name
ORDER BY
USERINFO.Badgenumber, DateValue([CHECKTIME]) DESC;