Documents
User documentation
QUERY buat cek data attendance di face recognition yang ada di file tarikan extension MDB
01/03/2025 04:11 PM
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
...
QUERY buat cek data attendance di face recognition yang ada di file tarikan extension MDB (versi compare sama db minova format tanggal nya )
01/13/2025 09:57 AM
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
...