Count total AppendQuery

[matrixindicator]

Hello,

In my code I need the total number of records of a few queries. If I try this with an action query access mentioned that you can't do this with an append query. Is there a way, because you can view an append query in design or in datasheet view.

Count2 = DCount("*", "001_QA")

 

[JerryKlmns]

You either have to make them a SELECT query or a SELECT Count(*) with the same FROM WHERE/HAVING GROUP BY clauses.

But if you execute them like

CurrentDB.Execute "ActionQueryName"
CurrentProject.Connection.Execute "ActionQueryName"

do include the optional (long type)parameter along with that command and get that to a variable

Dim myRecordsAffected As Long
CurrentProject.Connection.Execute "ActionQueryName", myRecordsAffected

MsgBox myRecordsAffected