Title:       
Web-Link: http://www.arabteam2000-forum.com/index.php?showtopic=120144
Description: Log IN/OUT Time
Department: Microsoft Access forum
Develop Using: Microsoft Access 2003
Assistant Tool(s): 
Version: 1.00
Last update: 10 March 2007
Date: 10 March 2007
Time Zone: (GMT + 02:00) Cairo
Author: Eng. Usama El-Mokadem: musama@hotmail.com

Topic(120144) [Mar 07 2007, 05:20 PM]: By Ashrouf: http://www.arabteam2000-forum.com/index.php?showuser=71395
=======
-----BEGIN TOPIC-----
  
  
        (   -- I or O)  
                          
  
-----NEW Update: Mar 08 2007, 05:32 PM-----
 
 
          
                 
 
             
            
       .
    
-----END TOPIC-----

Solution:
=======
-----BEGIN SOLUTION-----
 SQL Statement

SELECT USERINFO.NAME, USER_Alias.*, Format([OUTTIME]-[INTIME],"hh:nn:ss") AS WorkTime
FROM [SELECT CHECKIO.USERID, CHECKIO.CHECKTIME AS INTIME, (Select TOP 1 CHECKTIME From CHECKINOUT WHERE CHECKTYPE="O" AND CHECKIO.USERID = USERID AND CHECKIO.CHECKTIME < CHECKTIME) AS OUTTIME
FROM CHECKINOUT AS CHECKIO
WHERE CHECKTYPE="I"
GROUP BY CHECKIO.USERID, CHECKIO.CHECKTIME]. AS USER_Alias INNER JOIN USERINFO ON USER_Alias.USERID = USERINFO.USERID;

  
-----END SOLUTION-----

Attachments:
============
WorkTime.zip
The (Attached) Solution Suggested By Eng. Usama El-Mokadem: http://www.arabteam2000-forum.com/index.php?showuser=98027

CONTACT INFORMATION:
=======================
  Eng. Usama El-Mokadem
  Email: musama@hotmail.com
  Web: http://musama.tripod.com
  Mobile: 0020 10 1289308
  Egypt