select query

[realspido]

I have a table CREXPORT:

GH_1_1 DE_1 DE_2 DE_3
58001 27/6/06 7:00 In
58001 27/6/06 16:55 Out
58001 28/6/06 7:01 In
58001 28/6/06 16:59 Out
58002 27/6/06 7:04 In
58002 27/6/06 17:02 Out

How to make a query to get tblInOut:

NO DATE IN OUT
58001 27/6/06 7:00 16:55
58001 28/6/06 7:01 16:59
.....


PLEASE HELP!!!!!

 

[Svetlana]

SELECT DISTINCTROW CREXPORT.GH_1_1, CREXPORT.DE_1, First(CREXPORT.DE_2)
AS [IN], Last(CREXPORT.DE_2) AS OUT
FROM CREXPORT
GROUP BY CREXPORT.GH_1_1, CREXPORT.DE_1;

 

[Marshall Barton]

I have a table CREXPORT:

GH_1_1 DE_1 DE_2 DE_3
58001 27/6/06 7:00 In
58001 27/6/06 16:55 Out
58001 28/6/06 7:01 In
58001 28/6/06 16:59 Out
58002 27/6/06 7:04 In
58002 27/6/06 17:02 Out

How to make a query to get tblInOut:

NO DATE IN OUT
58001 27/6/06 7:00 16:55
58001 28/6/06 7:01 16:59

Insufficient data

You need some way to determine which Out goes with which In.