ACC2000: "Not A Valid Alias Name" Error When You Run a Query (248271)

MORE INFORMATION

Steps to Reproduce the Behavior

1. Open the sample database, Northwind.mdb.
2. Create the following union query that contains 22 Select statements:

   SELECT EmployeeID FROM Employees
   UNION ALL
   SELECT LastName FROM Employees
   UNION ALL
   SELECT FirstName FROM Employees
   UNION ALL
   SELECT Title FROM Employees
   UNION ALL
   SELECT TitleOfCourtesy FROM Employees
   UNION ALL
   SELECT BirthDate FROM Employees
   UNION ALL
   SELECT HireDate FROM Employees
   UNION ALL
   SELECT Address FROM Employees
   UNION ALL
   SELECT City FROM Employees
   UNION ALL
   SELECT Region FROM Employees
   UNION ALL
   SELECT PostalCode FROM Employees
   UNION ALL
   SELECT Country FROM Employees
   UNION ALL
   SELECT HomePhone FROM Employees
   UNION ALL
   SELECT Extension FROM Employees
   UNION ALL
   SELECT Photo FROM Employees
   UNION ALL
   SELECT Notes FROM Employees
   UNION ALL
   SELECT ReportsTo FROM Employees
   UNION ALL
   SELECT EmployeeID FROM Employees
   UNION ALL
   SELECT LastName FROM Employees
   UNION ALL
   SELECT FirstName FROM Employees
   UNION ALL
   SELECT Title FROM Employees
   UNION ALL
   SELECT TitleOfCourtesy FROM Employees;
   					

3. Save and run this query. Note that the query runs without error.
4. In Design view of this query, remove the semicolon from the end of the statement, and then append the following to the end of the statement:

   UNION ALL
   SELECT BirthDate FROM Employees;
   					

5. The union query now contains 23 Select statements. Save and run the query. Note that you receive the error message mentioned in the "Symptoms" section of this article.