Hello everyone,

This is my first post and I am sure after you read this, you will know that.

I have a database with employee_id, card_date, and card_time (along with numerous other fields). This is a database that keeps track of employees when they card in and card out. I am trying to create a query that will list each employee once, then for each date - list the earliest card time read and the last card time read (for each employee). Basically, when a person first cards in and when they card out for payroll purposes.

Any guidance would be greatly appreciated. I have spent countless hours trying to get this and I simply get each employee_id multiple time, card_date multiple times, and card_time multiple times.

Thanks!