General information
Category:
Coding, syntax & commands
Title:
Time attendance table for time-log
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only