Question Personnel tracking check in and out

Socarsky

Well-known member
Joined
Dec 27, 2012
Messages
173
Location
Jakarta/Indonesia
Programming Experience
Beginner
I have a mdb file that contain personnel's in and out in a company and below screen shot related that MDB file. I want to make a report that shows each personnel's in and out time difference as lower or higher than a normal daily working time per day in a month as a form of VB.NET. As you can see that field contains personnel's date as datetime data type. I found a way to get personnel's hour, minute and second with below query in MS Access but I need to make a report and it shows each row related a day of difference as minus and positive for a month in VB.NET form project. How to do that?
Here is my query example: SELECT USERID, CHECKTIME, DATEPART('h',CHECKTIME), DATEPART('n',CHECKTIME),DATEPART('s',CHECKTIME) FROM CHECKINOUT

83kp.jpg
 
Last edited:
Back
Top