split table and join it again side by side

[andi]

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

 

[Galaxiom]

SELECT qA.eid, qA.checktime AS checktimein, qB.checktime AS checktimeout
FROM 

(
SELECT eid, checktime
from checkinout
WHERE checktype = "I"
) AS qA

LEFT JOIN

(
SELECT eid, checktime
FROM checkinout
WHERE checktype = "O"
) AS qB

ON qA.eid = qB.eid

 

[andi]

i have tryed but still failed

can you make the way in this file,


if success please give the file,
and i will learn it

 

[CJ_London]

cross posted here

http://www.accessforums.net/showthread.php?t=64198

@Andi, please read this link http://www.excelguru.ca/content.php?184