hi guys,
i have a table, the name is CHECKINOUT and the table have fields, otherwise:
1. EID (this is a Employes ID, but this is not a primary key and indx is No)
2. CHECKTIME (this is a TIME and the format is ddmmyyy hh.mm.ss)
3. CHECKTYPE (this is a teks field and in that is I or O; I is In and O is Out
and my questions is
how to made a query from CHECKINOUT Table to be like this?
1. EID
2. CHECKTIMEIN (taken from CHECKTIME and CHECKTYPE with category I
3. CHECK TIMEOUT (taken from CHECKTIME and CHEKTYPE with category O
im sorry my english is bad
and thanks you for the care