AnsweredAssumed Answered

Merge Check In and Out Records

Question asked by ShaikhAtta on Jul 1, 2013
Latest reply on Jul 3, 2013 by ninja

Title

Merge Check In and Out Records

Post

     As you can see two tables tagged by Data Sheet and Required.  The Datasheet is a table with data of an employee's attendance CheckIn and CheckOut maintained in each record and the Required is the format I want to develop from the Datasheet. So, how can generate a layout/table or somthing where the similiar dates are merged/hidden or somthing and the CheckIn and CheckOut times are showed in a single row record. 

     Also if you notice in the DataSheet you will see in the record where the date is 11/02/2013 being showed 4 times thats because the employeed used his RFID card 4 times, now I also have to filter only the first (11/02/2013 9:55:20 AM) and last (11/02/2013 5:18:52 PM) from the records so only the first and last will be considered as CheckIn and CheckOut.

      

     Thanks for help in Advance.... 

CheckInOutRequired.png

Outcomes