second query doesn't require a where clause, but the first one does. Try
Code:
SELECT tblEmployees.EmployeeID, UCASE([UserName]) AS FullName, 1 As SortColumn, tblEmployees.ckinactive
FROM tblEmployees
WHERE tblEmployees.ckinactive = false
UNION SELECT 0,"<NEW EMPLOYEE>",0,0 FROM tblEmployees
ORDER BY SortColumn, fullname;
alternatively try
Code:
SELECT * FROM
(SELECT tblEmployees.EmployeeID, UCASE([UserName]) AS FullName, 1 As SortColumn, tblEmployees.ckinactive
FROM tblEmployees
UNION SELECT 0,"<NEW EMPLOYEE>",0,0 FROM tblEmployees) Q
WHERE Q.ckinactive = false
ORDER BY SortColumn, fullname;