This query worked because I had a 4 or 5 outstanding.
AreaSM: (Select [tblEmployee.EmployeeID]
FROM tblEmployee INNER JOIN
ON tblEmployee.EmployeeID =
And tblDesignatedEmployee.EmployeeTypeID In (4,5))
However, that may not always be the case. Right now I do have this condition exisiting. But what about when this is not true. For example, today Store # 1 has a District Manager. Tomorrow they may not. When that happens I need to designated a District Manager type of 5. Later on the store is assigned a DM. I changed the above query to read (1,5) and it gave me this error:
"An unhandled win32 exception occurred in MSAccess.EXE 
and Aceess quit.