Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Could you provide the preferred result from your row data?
Thank you
I need something like this:
name | date_entrance | date_exit | Date_Entrance2 | Date_Exit2 | total_hhmmss | Dif Between Timestamp |
STAFF1 | 02/11/2018 16:25 | 02/11/2018 17:37 | 02/11/2018 | 02/11/2018 | 01:12:00 | 01:12:00 |
STAFF1 | 05/11/2018 16:10 | 05/11/2018 18:01 | 05/11/2018 | 05/11/2018 | 01:51:00 | 01:51:00 |
STAFF1 | 06/11/2018 16:08 | 06/11/2018 17:27 | 06/11/2018 | 06/11/2018 | 01:19:00 | 01:19:00 |
STAFF1 | 07/11/2018 16:04 | 07/11/2018 17:53 | 07/11/2018 | 07/11/2018 | 01:49:00 | 01:49:00 |
STAFF1 | 08/11/2018 16:08 | 08/11/2018 18:05 | 08/11/2018 | 08/11/2018 | 01:57:00 | 01:57:00 |
STAFF1 | 12/11/2018 16:07 | 12/11/2018 18:16 | 12/11/2018 | 12/11/2018 | 02:09:00 | 02:09:00 |
STAFF1 | 13/11/2018 16:26 | 13/11/2018 17:46 | 13/11/2018 | 13/11/2018 | 01:20:00 | 01:20:00 |
STAFF1 | 15/11/2018 16:10 | 15/11/2018 18:06 | 15/11/2018 | 15/11/2018 | 01:56:00 | 01:56:00 |
STAFF1 | 16/11/2018 16:05 | 16/11/2018 16:26 | 16/11/2018 | 16/11/2018 | 00:21:00 | 00:21:00 |
STAFF1 | 20/11/2018 16:04 | 20/11/2018 17:26 | 20/11/2018 | 20/11/2018 | 01:22:00 | 01:22:00 |
STAFF1 | 21/11/2018 16:13 | 21/11/2018 17:42 | 21/11/2018 | 21/11/2018 | 01:35:00 | 01:29:00 |
STAFF1 | 21/11/2018 17:42 | 21/11/2018 17:54 | 21/11/2018 | 21/11/2018 | 01:35:00 | 00:12:00 |
STAFF1 | 22/11/2018 16:09 | 22/11/2018 17:32 | 22/11/2018 | 22/11/2018 | 01:23:00 | 01:23:00 |
STAFF1 | 26/11/2018 16:08 | 26/11/2018 18:06 | 26/11/2018 | 26/11/2018 | 01:58:00 | 01:58:00 |
STAFF1 | 03/12/2018 16:26 | 03/12/2018 17:50 | 03/12/2018 | 03/12/2018 | 01:24:00 | 01:24:00 |
thanks!