Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to show in the table the number of holidays per person whatever else is selected, but just the persons in the selected departments. So for example if department1 is selected I want miller and smith with two holidays.
Has someone an idear how I can solve this problem?
Greatings
m.sonnenschein
The field Holiday contains nulls which are not included in the count. You can use any other field like date: COUNT(Date)
Marius,
Are you sure that your Holiday table should even be connected to your Work table? The reason only one of the holidays counts up is because nobody worked on 01.01.2014. Therefore when you select something in the Work table, it will definitely filter out that date and depending on your selection might also filter out 06.01.2014.
Is this what you are interested in seeing?
so thats my problem and I have no idea how to solve this.