topdesk123
Programmer
Good morning - I have numerous combo boxes throughout my program forms that users can choose the Employee's Name for various reasons. The Employees Name information comes from the Employees table obviously. I also have criteria set: "terminationdate=null", so that only current employees can be selected. Problem is, previously selected employees who have since become terminated no longer show up on the forms. I have tried every combination I can think of to store the data and have been unsuccessful. Does anyone have any ideas?
Here is the actual:
SELECT Employees.EmployeeID, Employees.FirstName, Employees.LastName, Employees.TerminationDate, [firstname] & " " & [lastname] AS Expr1
FROM Employees
WHERE (((Employees.TerminationDate) Is Null))
ORDER BY Employees.FirstName, Employees.LastName;
TIA!
Here is the actual:
SELECT Employees.EmployeeID, Employees.FirstName, Employees.LastName, Employees.TerminationDate, [firstname] & " " & [lastname] AS Expr1
FROM Employees
WHERE (((Employees.TerminationDate) Is Null))
ORDER BY Employees.FirstName, Employees.LastName;
TIA!