I was hoping someone could help with the following issue. I am trying to sort out the first time someone swipes their door access card and the last time they swipe their door access card each day. I have the below query:
SELECT Sheet1.[emp_id], Sheet1.[card_date], Sheet1.[card_time]
However, this gives me a list of each time a person cards in/cards out for each day. I would like to just have the name listed once for each date and the first time swiped and last time swiped for each date.