December 16th, 2016, 09:35 PM
Counting with condition
Looking to try and count the number of times two different employees have taken a morning and an evening off on the same day
So if employee John has taken the morning off. And that day Suzy takes the evening off I want to count as 1
I can do it with one or the other. But not both conditions at once on the same date.
December 16th, 2016, 11:12 PM
please show both
Originally Posted by SGC3
December 17th, 2016, 07:25 AM
It would really help us to help you if gave us some clues about your data (structure and content).