Performing count in VBA

[jgelpi16]

I'm not sure if this is going to be an easy fix, but gotta ask. I have this SQL statement that I want to run in VBA. The append part does not bother me, it is the count part that bothers me. Any suggestions?

INSERT INTO tblCountAssign ( CountOfAuto, RV )
SELECT Count(AcctPeriods.Auto) AS CountOfAuto, AcctPeriods.RV
FROM AcctPeriods
WHERE (((AcctPeriods.RV)=[Forms]![SfrmAssign]![cboRACF]))
GROUP BY AcctPeriods.RV;

[jgelpi16]

I am getting a syntax error of missing operator

    mySQL = "INSERT INTO tblCountAssign (CountOfAuto, RV ) SELECT (Count(AcctPeriods.Auto) AS CountOfAuto, AcctPeriods.RV) FROM AcctPeriods WHERE (((AcctPeriods.RV) = varRACF))GROUP BY AcctPeriods.RV;"
    CurrentDb.Execute mySQL, dbFailOnError

[ajetrumpet]

check this out:

http://office.microsoft.com/en-us/ac...001231483.aspx


using a GROUP BY needs a HAVING clause as a substitute for the WHERE clause doesn't it? HAVING comes after GROUP BY clause as well, which is different than the WHERE clause.

[jgelpi16]

Thank you!