What is wrong with this SQL statment?

I've the following SQL statment to retrieve some fields from 2 Access database tables (Carros and Concerns). I'm getting an error about the Data_Audit field saying that I've tryed to execute a query that doesn't include the expression specified "Data_Audit" as part of the agregation. (don't mind the translation because I'm translating the error message from Portuguese version!).

What is wrong with this SQL statment?

Thanks,

João PintoStart Free Trial

1:

sSQL = "SELECT Carros.Kenn, Carros.Pontos_Area, Data_Audit, Sum(Concerns.Pontos) AS PontosInseridos FROM Carros INNER JOIN Concerns ON Carros.Kenn = Concerns.Kenn GROUP BY Carros.Kenn, Carros.Pontos_Area"