Query - Combining IF statements (?) HELP 1

[Dedicated]

Emp2: IIf(([Empl2Name]<>[EmployeeN]) Or ([CaseC]=-1) And ([Empl2Name]=True),[Empl2Name],Null)

Emp5: IIf(([EmployeeN]=True) And ([Empl2Name] Is Null) And ([CaseC]=-1),[EmployeeN],Null)

How do I combine these 2 "IF" statements. I need to pull a report on all employees from both Emp2 & Emp5.

 

[PaultheS]

IIf(([Empl2Name]<>[EmployeeN]) Or ([CaseC]=-1) And ([Empl2Name]=True), [Empl2Name], IIf(([EmployeeN]=True) And ([Empl2Name] Is Null) And ([CaseC]=-1),[EmployeeN],Null))

 

[Dedicated]

PaultheS...Thank you soooooooo much!