I have a project to calculate the time duration for each employee each day he get inside the site. the data coming from 2 linked database. the duration should be calculated from alarm event table any time the employee access one of dedicated gate. I have
add a sub-query on my root query to aggregate the clocking-in and clocking-out. The case give ’01’ as clocking-in and ‘02’ as clocking-out.
Now what is missing is calculating the duration time each employee worked each day provided that he/she might clock-in and clock-out several time a day or he/she might work on shift between two day.
please help me complete my attached script
CardHolderTable.FirstName + ' ' + CardHolderTable.LastName AS [Emp. Name],
ViewSMSCardHolderPersonalData1_25.[Personal Data 2] AS Department,
ViewSMSCardHolderPersonalData1_25.[Personal Data 3] AS [Job Title],
ViewSMSCardHolderPersonalData1_25.[Personal Data 5] AS [Company Name],
ViewSMSCardHolderPersonalData1_25.[Personal Data 6] AS [Projec
View Complete Post