Guys, hello
I have the following report from access system for the Staff and i need to make a control access application per day where i can sum total_hhmmss for each day and compare the field Total_hhmmss with the difference between date_entrance and date_exit for check if the report works properly.
| name | total_hhmmss | date_entrance | date_exit |
| STAFF1 | 01:12:00 | 02/11/2018 16:25 | 02/11/2018 17:37 |
| STAFF1 | 01:51:00 | 05/11/2018 16:10 | 05/11/2018 18:01 |
| STAFF1 | 01:19:00 | 06/11/2018 16:08 | 06/11/2018 17:27 |
| STAFF1 | 01:49:00 | 07/11/2018 16:04 | 07/11/2018 17:53 |
| STAFF1 | 01:57:00 | 08/11/2018 16:08 | 08/11/2018 18:05 |
| STAFF1 | 02:09:00 | 12/11/2018 16:07 | 12/11/2018 18:16 |
| STAFF1 | 01:20:00 | 13/11/2018 16:26 | 13/11/2018 17:46 |
| STAFF1 | 01:56:00 | 15/11/2018 16:10 | 15/11/2018 18:06 |
| STAFF1 | 00:21:00 | 16/11/2018 16:05 | 16/11/2018 16:26 |
| STAFF1 | 01:22:00 | 20/11/2018 16:04 | 20/11/2018 17:26 |
| STAFF1 | 01:29:00 | 21/11/2018 16:13 | 21/11/2018 17:42 |
| STAFF1 | 00:12:00 | 21/11/2018 17:42 | 21/11/2018 17:54 |
| STAFF1 | 01:23:00 | 22/11/2018 16:09 | 22/11/2018 17:32 |
| STAFF1 | 01:58:00 | 26/11/2018 16:08 | 26/11/2018 18:06 |
| STAFF1 | 01:24:00 | 03/12/2018 16:26 | 03/12/2018 17:50 |
Thanks!
