SELECT empid, MIN(swipetime) as Time1 FROM times ; GROUP BY empid ; INTO CURSOR curStartTimes nofilter select Your_Other_Table append from curStartTimesTo 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..