Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2015

    Unanswered: Time Clock Query

    I use Access 2010 in my office and 2013 at home and often develop databases between both versions of Access. Please keep in mind I am a new user and giving me instructions without telling me how to get to certain parts of Access will not be helpful. I see most answers in this forum assume a user is an expert.

    The problem I am having is almost exclusively in Access 2010. I developed a time clock with two subforms in a parent form. One subform tracks employee punches in while the other tracks employee punches out. Each record posts to its own table (Table1 and Table2 respectively).

    I'm trying to query each table so I can compare a punch in with a punch out to determine how much time a person worked in a given shift, but I'm running into a problem where every punch in for a particular person matches with every punch out. This makes my query needlessly long and terribly difficult to sort through to identify a person's worked hours. Is there a way I can pair one punch in to a person's next punch out?

    Provided is a screenshot of my query and of my relationships. IDOne and IDTwo are my primary keys in each table. Anything denoted by a "One" belongs with Table1 and anything denoted by a "Two" belongs with Table2.

    Any feedback is appreciated. I've worked to solve this problem for a week and can't come up with any ideas.

    Click image for larger version. 

Name:	Time Clock Query Screenshot.png 
Views:	6 
Size:	302.7 KB 
ID:	16429Click image for larger version. 

Name:	Relationships.png 
Views:	4 
Size:	207.8 KB 
ID:	16430

  2. #2
    Join Date
    Apr 2014
    Provided Answers: 35
    answered on the other site

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts