Forum Discussion
Access control reports
Would dearly appreciate a set of fresh eyes. I've been tasked with building a report that provides some insights as based on data from an access control db (sample data attached) The idea is to prov...
Hi Daniel
Yes, TIME ON SITE and RANKING would be what is required as output.
Logic with regards to the TIME ON SITE...... Conceptually I wanted to work out the earliest and latest time per person per day. Then subtract latest with earliest to get to the amount of time spent on site per day. Then add all the daily totals to get to the monthly total.
Any ideas?