Merge Check In and Out Records
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....