AnsweredAssumed Answered

Summary from related table

Question asked by normanbates77 on Dec 6, 2018
Latest reply on Dec 7, 2018 by keywords

I am at a loss here. I have 2 tables, Time and Employees. In the Time table, working times is registered in the fields Name, Date, Project and Workingtime. They can register more than 1 record per day if they are on multiple projects that day. The problem is that I from the Employees table want to sort out the employees that havent reported any time, or a total time that is less than 8 hours for a specific date. I could probably do some looping script but i guess there is a much more simple way to achieve this?

Outcomes