I need help to with an attendance table in access, in my company we have a single card reader which provides access in/out of the facility.

I was able to extract from the software an excel sheet which I later imported to access, the column headers(fields) are in a temporary table as follows.

The problem is staff go in & out of the facility a lot during the course of the day, I need to get the first and last entry time for each day per CardID to add to another table.

```
*AttendanceDate* - *AttendanceTime* - *CardID*
10/09/2017 - 08:00:00 - 123  
10/09/2017 - 09:20:00 - 123  
10/09/2017 - 10:00:00 - 123  
10/09/2017 - 15:00:00 - 123  
10/09/2017 - 09:00:00 - 675  
10/09/2017 - 12:00:00 - 675  
11/09/2017 - 09:00:00 - 675  
11/09/2017 - 16:00:00 - 675  

```

I need to create a query that will get the for every cardID the first and last record of time per day and append it to another sheet to get the results like this.

```
*AttendanceDate* - *EntryTime* - *ExitTime* - *CardID*
10/09/2017 - 08:00:00 - 15:00:00 - 123  
10/09/2017 - 09:00:00 - 12:00:00 - 675  
11/09/2017 - 09:00:00 - 16:00:00 - 675  

```

Is this even possible?