[AccessD] Append Query syntax error

The following select query works great

SELECT Count(A.PID) AS [Active Flowing Count],EngArea 
FROM (SELECT DISTINCT A.PID, EngArea 
FROM [tbl Statuses During Prior Month] AS A 
WHERE(A.Status In ("FL","FM","FH"))) 
Group by EngArea;

When I tried to make it an append query I get a syntax error. I don't see the error. Maybe someone else can

INSERT INTO [tbl Monthly Well Count](Count(A.PID) AS [Active Flowing Count],EngArea) 
FROM (SELECT DISTINCT A.PID, EngArea 
FROM [tbl Statuses During Prior Month] AS A 
WHERE(A.Status In ("FL","FM","FH"))) 
Group by EngArea;

Thanks


Chester Kaup
Engineering Technician
Kinder Morgan CO2 Company, LLP
Office (432) 688-3797
FAX (432) 688-3799

 
No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.