Using the PS_Personnel table, how can I select all employees who were active during a time period (ex. Jan 1 2010 - Dec 31 2010). When I select employees hired or rehired before Dec. 31, those terminated after Jan. 1, and those with no termination date, the report excludes rehired employees where a termination date exists in their record.