Richard Corso Posted September 18, 2009 Share Posted September 18, 2009 Hello All, I am working on a time clock for work. I was reading some of the forms and started with the template Personnel Records for the back end. Then with the thought that we would use a the card swipe we use for the gift cards to swipe our drivers license (the DL field is not yet Meddled). The way it works, click the “In” or 'End” )then you would swipe) type 123 and hit the enter click on “Stamp”. My problem is getting the timestamps to add up for each worker. Any thought on this would be greatly appreciated. I have added the solutions. time_clock.zip Link to comment Share on other sites More sharing options...
comment Posted September 18, 2009 Share Posted September 18, 2009 You don't need to add up the timestamps for each worker - that would be meaningless. You need to subtract the "In" timestamp from the corresponding "Out" timestamp. For this, you must have a (self-join) relationship between an "Out" record and the previous "In" record of the same employee. The real challenge here, IMHO, is making sure there are no "In" entries without a corresponding "Out" and vice versa - see also: http://fmforums.com/forum/showtopic.php?tid/175706/post/202337/#202337 http://fmforums.com/forum/showtopic.php?tid/175706/ Link to comment Share on other sites More sharing options...
Richard Corso Posted September 18, 2009 Author Share Posted September 18, 2009 Thanks, maybe I am over my head on this one. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5355 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now