Time and Attendance records

Question

Hi ,

I'm currently doing a time & attendance project. its like when i click the download button, the code and dlls communicates with the attendance reader and fetches the datas in the following format(sql) ,

empCode in/outMode  date      time
5001  0  12/09/2011  09:05:34
5002  0   12/09/2011  09:33:13
5001  1   12/09/2011  18:05:09
5002  1   12/09/2011  17:44:34

where , in the in/out mode , o is the intime and 1 is the outtime.

i want to show these datas in a single record for each employees. that is , i want to show somethng like the following , (assume that i created a new table as below) ,

empCode  date      intime  outtime
5001  12/09/2011  09:05:34  18:05:09
5002  12/09/2011  09:33:13  17:44:34

How do i do that?.. can anyone pls guide me?...