Calculating date differences for multiple records

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • rodneyeid
    New Member
    • Dec 2007
    • 1
    #1

    Calculating date differences for multiple records

    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 counting the day as being from 12:00 am till 11:59 pm

    can anyone help please.
    Tags: None
    • puppydogbuddy
      Recognized Expert Top Contributor
      • May 2007
      • 1923
      #2
      Originally posted by rodneyeid
      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 counting the day as being from 12:00 am till 11:59 pm

      can anyone help please.
      See the section on calculating elapsed time at this link (source code provided):

      Your request has been blocked. This could be due to several reasons.
      http://office.microsoft.com/en-us/access/HA011102181033.aspx

        Comment

        Previous template Next
        Working...