Insert with count records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

uGek - 15 Dec 2005 15:24 GMT

I am trying to insert the results from a recordset into a table. I have my
sql statement and it appears to work fine when I run it on its own function
but it is not doing what I am telling it to do. Can anyone see what I am
doing wrong? Thanks
this is my sql statement.
----------------------------------------------------------------------------------------------
strSqlDump = "INSERT INTO fldTempCountByRDO (fldCountOfRDO, fldRDO, fldName)
Select Count(tblPC01.fldRDO) AS CountOffldRDO, fldRDO, fldName FROM tblPC01
WHERE fldRepMonth = '" & strRptMonth & "' GROUP BY fldRDO, fldName ORDER BY
fldName"

CurrentDb.Execute strSqlDump

----------------------------------------------------------------------------------------------

Reply to this Message

Tim Ferguson - 15 Dec 2005 18:16 GMT

> but it is not doing what I am telling it to do.

So, what is it doing and what do you thing you told it to do?

INSERT INTO fldTempCountByRDO (
fldCountOfRDO,
fldRDO,
fldName)
SELECT
COUNT(tblPC01.fldRDO) AS CountOffldRDO,
fldRDO,
fldName
FROM tblPC01
WHERE fldRepMonth = '" & strRptMonth & "'
GROUP BY fldRDO, fldName
ORDER BY fldName

B Wishes

Tim F

Reply to this Message