Recent content by jlolt

Thank you for your responses. I tried your query (see below) but it still doubled counted the mins of overlapping tickets. SELECT [UserID], [EntryDate], Sum(DateDiff("N",[TimeIn],[TimeOut])) AS ElapsedMinutes FROM MyTable WHERE (([EntryDate]>=#1/11/2019#) AND ([EntryDate]<=#1/12/2019#)) GROUP...

See Data Below: User Ticket Entry Date Time In Time Out A 1 3/11/2019 8:07:00 PM 9:00:00 PM A 2 3/11/2019 6:21:00 PM 8:39:00 PM A 3 3/11/2019 5:54:00 PM 7:58:00 PM A 4 3/11/2019 5:51:00 PM 7:13:00 PM A 5 3/11/2019 5:30:00 PM 5:50:00 PM A 6...

Hello, I've been using Access for quite some time but, do not consider myself an expert. I am completely stuck on something and need some help. I have a database where users enter in tickets. Part of their entry process includes entry date, time in and time out (meaning opening the ticket...