Search results

Dear all, I have an attendance database as follows: tbl_Attendance Employee_ID IN/OUT Flag Datetime Is it possible to create a query which selects and merges the Datetime according to the IN/OUT Flag? i.e. I want my query to spit out: qry_Attendance Employee_ID Time IN Time OUT Date

Hi all, I currently have a query designed to return the records for a range of dates. Criteria: Between [Enter Date] And DateAdd("d",1,[Enter Date]) The main problem with this is that the user enters the data in dd/mm/yy, but the system records it as being mm/dd/yy instead. Is there any...

Hmm.. I feel like an idiot, but after fiddling around with the tables, I still can't figure out how to calculate overtime with the data fixed in this format. Could you provide a brief outline of how to calculate the difference between a matching IN and OUT time? Thanks in advance.

Thanks for the reply. However, if we store the data in that format, how can the corresponding IN-OUT dates/times be linked together? I plan to add an overtime calculator as well, which would require both the IN and OUT times for the same shift.

Hi all, First off, I'll admit that I'm rather new at this, so please let me know if I'm doing this right. I'm building a very simple database to keep track of the clock-in and sign-out times for a list of employees. I have tbl_checkin that contains the IN time, tbl_checkout to manage the...

Hi all! Winston here, a self-proclaimed Microsoft Access greenhorn. All knowledge thus far have been self-taught, and I'm still meddling in the earlier stages of Access. Nice to meet y'all!