Hi,

To find First Swipetime

SELECT empid, MIN(swipetime) as Time1 FROM times ;
GROUP BY empid ;
INTO CURSOR curStartTimes nofilter

select Your_Other_Table
append from curStartTimes

To find last swipetime

SELECT empid, max(swipetime) as Time4 FROM times ;
GROUP BY empid ;
INTO CURSOR curFinishTimes nofilter

select Your_Other_Table
append from curFinishTimes

>I have a table with userid, swipedate, swipetime.. this is a database for our door access.. which records all the door out and in of our employees.. this will also be the daily time record for our time attendance..
>
>I'd like to select from this table:
>
>1. The employee's first swipe as her time-in in the morning..
>2. The employee's last swipe as her time-out in the afternoon..
>3. Also, the employee's swipe in-out after 12 noon as his time-out-in during lunch break..
>
>I'd like to save this into another table.. with fields userid, swipedate, time1, time2, time3, time4.. to record her attendance for the day..
>
>How can I achieve this?