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.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Active Employees for a Specified Time Period
- Thread starter mmcelwee
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question