When a recordset is created from a SELECT statement, the table's column names become the column names in the Recordset. If you want different column names, use the AS clause. The following example uses the title "DOB" to name the returned BirthDate column from the Employees table:
SELECT BirthDate AS "DOB"
FROM Employees
Whenever you use queries that return ambiguous or duplicate Field object names, you must use the AS clause to provide an alternate name for the Field. The following example uses the title "Head Count" to name the returned Field in the resulting Recordset:
SELECT COUNT(EmployeeID) AS "Head Count"
FROM Employees