In my tblEmployeeType we can have multiple different types of employees. Stores are designated different types of employees, e.g. District Manager, Area Support Manager, Store Manager and Assistant store manger. My query belows relates to one type, Area Support Manager. I need to evaluate such when a store has an Area Manager = 4 disregard the employee type 5 which represents unassigned. Right now I'm only looking a 5, none assigned. I tried incorporating a or but that failed.
AreaSupportManager: (Select [tblEmployee.EmployeeFirstName]
&" "&[tblEmployee.EmployeeLastName] AS ASMName
FROM tblEmployee INNER JOIN tblDesignatedEmployee
ON tblEmployee.EmployeeID = tblDesignatedEmployee.EmployeeID
Where tblDesignatedEmployee.StoreID = tblStore.StoreNumberID
Prior related question: http:/Q_27392794.html