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

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/

Thanks, maybe I am over my head on this one.