This one is interesting

[Gsoldado]

Well the idea is that the program is reading data from a
digital clock, the guys in the company, of course, use to pass theyr cards more than once (they want to ensure) so when I get the lists from the clock, there is data like

EMPLOYEE DATE TIME
marcus 01/01/01 00:00:01
marcus 01/01/01 00:00:06
marcus 01/01/01 00:00:09
Floyd 01/01/01 00:02:32
Petrus 01/01/01 00:03:01
Casey 01/01/01 00:04:01
Casey 01/01/01 00:04:07
Casey 01/01/01 00:04:19

----

what I need is to eliminate the redundant data, and get only
the earlier event.

thanks in advance

 

[tlbroadbent]

The following query will find the first or minimum time for each day for each employee.

Select EMPLOYEE, [DATE], Min([TIME]) As FirstTime
From Tbl
Group By EMPLOYEE, [DATE]

I recommend NOT using DATE and TIME as column names because they are ODBC reserved words. Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[Gsoldado]

it works! and don't worry the fiels date and time were only for explanation purposes, but anyways thank you for the worry.

alex