Pull active employee jobcode from dept unless

[ttrsnoob]

I am trying to pull a report that will show all DEPTIDs between '000100' and '009000'. I need the report to then pull the active employee's EMPLID with JOBCODE 12104 (there will only be 1 employee with that jobcode) If there are only terminated employees with jobcode 12104 I still want the deptid to show but have no employee show

example
DEPTID 100 EMPLID 12345 JOBCODE 12104
DEPTID 101 EMPLID 23456 JOBCODE 12104
DEPTID 102 EMPLID JOBCODE 12104

right now it will pull 2 lines for each DEPTID when there is an active and terminated employee and only 1 line when there is only terminated employees in the DEPTID

 

[ttrsnoob]

Nevermind I figured it out =)