I have a database that contains start and finish dates for individuals working on projects. I am trying to create a query that will identify individuals that have time available during a defined period. The defined period is being input as part of the query, and I have that part worked out.
Example:
Employee Project Startdate Enddate
Jane Sale 10/10/2014 10/12/2014
Jane Present 10/15/2014 10/16/2014
Sam Sale 10/10/2014 10/22/2014
Fred Sale 10/12/2014 10/19/2014
If I use the period 10/10/2014 to 10/20/2014 I want to see all users who are available. From the above:
Employee Startdate Enddate
Jane 10/13/2014 10/14/2014
Jane 10/17/2014 10/20/2014
Fred 10/10/2014 10/11/2014
Fred 10/20/2014 10/20/2014
Dates are mm/dd/yyyy.
I have minimal SQL knowledge but am not against using it if it will help.
Thank you in advance for your assistance.