Hi, I have an Access 2016 database which has a table with user sessions (session ID's, application name, session start date/time and session end date/time). I need to find out the maximum concurrency for each application for each date.
I currently have a query as below which is taking too long (20 mins) to run but also comes out with only one day. Please can someone help with the algorithm for concurrency calculation for Access?
SELECT TOP 1 Count(*) AS ['concurrency'], T1.Date
FROM table AS T1, table AS T2
WHERE (((T1.startTime_f) Between [T2].[startTime_f] And [T2].[endTIme_f]))
GROUP BY T1.usersessionID, T1.Date, t2.date;