DEPARTMENT: IIf([dbo_p21_view_inv_mast]![badge_no] Like [5????], "DEPARTMENT X",(IIf([dbo_p21_view_inv_mast]![badge_no] Like [6????], "DEPARTMENT Y", (IIf([dbo_p21_view_inv_mast]![badge_no] Like [8????], "DEPARTMENT Z")))))
NOTE: IIf([dbo_p21_view_oe_line_x_employee]![BADGE_NO] Is Null,[dbo_p21_view_oe_line]![EXTENDED_DESC],[dbo_p21_view_oe_line_x_employee]![BADGE_NO])