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...

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!