Time In and Out Problem: Please help..
Hi guys, I am using Filemaker Pro 11 Advanced using Windows operating system. I have only 2 tables, Employee and AccessLog table. It's already working with time in and time out capabilities. When the employee scan or manually encode his/her number for the first time it will record the time in TIME IN field and the second time he do it, it will record the time in the TIME OUT field and then TIME IN and TIME OUT and so on..
The problem I noticed is that if this person has a TIME IN and TIME OUT record for this day (Tuesday-09/10/2013) and the last record he/she did is only up to TIME IN and NO TIME OUT what happened is that the next day he/she log in that supposedly record in TIME IN for (Wednesday- 09/11/2013) will record in the TIME OUT of (Tuesday - 09/10/2013) which I found not good for the system. The date and time is not the same of what is the real scenarios happened.
Any idea please help..