Hi,
Basically, I've got to separate queries. 1st that shows services in a given time frame (defined by user) and 2nd that shows not allocated employees (using "Is Null").
What I need now is how to combine the two queries taking into account the fact that employee might be allocated to a job this week, but available the next week (which the 2nd query does not show).
I want user to define time frame and the query to show employees which are not allocated in this time frame.
Cheers,
Basically, I've got to separate queries. 1st that shows services in a given time frame (defined by user) and 2nd that shows not allocated employees (using "Is Null").
What I need now is how to combine the two queries taking into account the fact that employee might be allocated to a job this week, but available the next week (which the 2nd query does not show).
I want user to define time frame and the query to show employees which are not allocated in this time frame.
Cheers,