So you have two readers which can record a stamp but you don't know if the stamp is for entry or exit, so the reader id is irrelevant?

Do you have a shift table?[/quote]

Hi Chris. Yes we have 2 reader which save the record to the sql. i know the entry and exit of the reader. reader id is relevant, see im using that reader before to capture the first in and the last out of the employees using case.

no i dont have shift table. Luis Cazares and wolfkillj suggestion is the one that would work unfortunately i dont how to do this in sql.

thanks.