hi,
\r\ni want to make a report of employee\'s daily attendance.
\r\nAt which time employee entered and exit.
\r\nFields of Database are:-
\r\nEid ,AtdTime ,AtdDate
\r\n
\r\nAtdTime saves employee enter time and another record containing exit time. Like :-
\r\nEid AtdTime AtdDate
\r\n1 10:00:00 23-8-2004 (intime record)
\r\n1 6:00:00 23-8-2004 (outtime record)
\r\n
\r\nso when i generate the report it is printing both two records for the same employee ,what i want is it should generate a report of single employee in one row only ..Like
\r\n Eid inTIme OutTime
\r\n 1 10:00:00 6:00:00
\r\n 2 11:00:00 4:00:00
\r\n etc
\r\nso how should i generate this report with only one field of Time used for saving in time and out time ?
\r\nthanks