I am at a loss for a select query that produces times that employees punches for the day. What I am struggling with is filtering the results to that only the last punch of the day is selected. An example would be like this:
UniqueID EmployeeID TimeOut
268372524 100596 1713
268372525 100596 2344
The first punch for time out is actually a transfer from one job code to another and I want to remove that from my query.
Any help is appreciated.