Building a Time Clock in Access 2007
Posted on 2010-08-14
Here is what I am attempting to accomplish....
The owner of the company I work for wants to start using an Access database to track and report employee hours. The premise is that our employees open the database and click one button that basically enters their clock punch times in to the database.
I have created a table that holds the "time punches" every time a button is clicked on a form.
It creates a new record attached to the employee name when the button is pushed.
The problem I am having is figuring out how to calculate the time difference between each punch. I know how to use the DateDiff function, but I guess the problem I am having is identifying the different records in order to calculate two different times or dates.
Am I approaching this the wrong way?
Is there something that I am missing?
I am by no means an Access expert. I know quite a bit, but I know that there is much more I do not know.
Any help or suggestions would be appreciated.