Hi eveybody, I need to figure out a query on a database I am working.
Basically the records are coming from a MS SQL server and I am pulling something similar to the info below:
userid date date/time
10325 10/14/2018 10/14/2018 7:01:08
12532 10/14/2018 10/14/2018 7:05:03
10584 10/14/2018 10/14/2018 8:30:01
10325 10/14/2018 10/14/2018 13:31:02
10325 10/14/2018 10/14/2018 14:30:05
10325 10/14/2018 10/14/2018 17:08:02
12532 10/14/2018 10/14/2018 13:01:34
10584 10/14/2018 10/14/2018 14:08:03
10325 10/14/2018 10/15/2018 7:35:03
10325 10/15/2018 10/15/2018 13:14:12
These are records when the employees punched in and punched out from work. I need to get a query that shows the following:
userid date punchin punchout
10325 10/14/2018 7:01:08 13:31:02
10325 10/14/2018 14:30:05 17:08:02
12532 10/14/2018 7:05:03 13:01:34
10584 10/14/2018 8:30:01 14:08:03
10325 10/15/2018 7:35:03 13:14:12
Is this even possible ? I need to group them by userid and date, then to make sure the punchin is earlier than the punchout, is only one pair of punches is available, do not show it. No changes on the MS SQL server can be done before bringing the data. Eveything has to be done in Access.
Any help is appreciated.