Hi,
I have an attendance machine which saves records in an Access Database in the following format : UserID DATE/TIME Checktype
where if checktype is 0 then its check in and if it is 1 then it check out

I need to calculate number of hours for each userID /day.

I.e UserID =1 DATE/Time= 11/12/2007 12:36 P.M CheckType=0
UserID = 1 DATE/Time= 11/12/2007 17:36 P.M CheckType=1
i am...