Recent content by Mauricianstyle

Hi, Thank you very much for all your answers. That really helped me. I will make a Macro to change my records.

Here is two excel files. LOG : First Tab the Initial log from the software and the second Tab the initial log + the new record for the user23. Tables : These are the lists that i will import into my Access Database. (Here I put it in the same file but when imported it will be in three...

Hi, Thank you for your answer. I have created a new record for the user23 and it is working very well. In that example i have few records so I modified it manually. In my table I have about 60 000 records To feed my databasse I have created a macro that import an Excel file...

I need to have the peak connection for each day from 00:00AM to 11h59PM. When a user logged in the 12/05/15 and logged out the 13/05/15. We must have a Maxcount for the 12/05/15 from 00:00AM to 11h59PM. And for the 13/05/15 From 00:00AM to 11h59PM.

Hi, I import the data into a pivot table in Excel and i had the result i sent you in my last post. For the date 12/05/2015 we have a peak of 7 but we should have 4 (User20, User21, User22, User23). I would like the peak only for one day and not from 12/05/2015 to 13/05/2015. Thank you

Hi, Here is the spread sheet format attached. The User23, logged in the 12/05/2015 and logged off the 13/05/2015. Can we split it into 2 different dates to have a MaxCount by date ? Thank you

I would like that result. See attached Thank you.

Ok thank you. For the final result, how can I have the peak connection for each day within the last thirty days ?

Hi, Thank you for the access file. I don't understand why do we have "3" on the "overlapcount" column for the "User20" ? Many thanks for your help.

To test that query I have just 1 table in which I import few records. LOG (ID, User, Date_logon, Time_logon, Date_logoff, Time_logoff) SELECT A.*, (SELECT Count(*) FROM LOG AS B WHERE ( B.Heure_connexion > A.Heure_deconnexion OR B.Heure_deconnexion <...

Hi, Please find attached the result of the query. I have a result on each line. Thank you

Hi, Thank you very much for your answer. I will try this week end.

Hi, I am effectively looking for overlapping start and end times. The aim of that query is to know how many licenses do we need for that software. It is a concurrent use license.

User2 logged in the software from 17:12:21 to 17:30:24 AND User3 logged in the software from 16:59:08 to 17:16:06 The time interval of user3 [16:59:08 to 17:16:06] is in the time interval of user2 [17:12:21 to 17:30:24]. So we have a maximum of 2 users who use the software. Sorry I made...

These data are event log from a software. So user1, user2, user3 and user4 use the software at the same time.