How to add counter to StrSQL vba?

[Jo..]

I am trying to add DCount Expression to my query. But it does not seem to be working. Please help!!!



The Code I am trying to use:

MyRS = MyDB.OpenRecordset("SELECT *, DCount("[ProductDescription]", "[myQQQuery]", "[ProductDescription] <='" & [ProductDescription] & "'") AS RowNum FROM myQQQuery;", dbOpenSnapshot)

How to convert it?

[JamesDeckert]

Dcount doesn't put the query name in square brackets in any of the reference that I see.
http://www.techonthenet.com/access/f...ain/dcount.php
https://msdn.microsoft.com/en-us/lib...or=-2147217396

try
MyRS = MyDB.OpenRecordset("SELECT *, DCount("[ProductDescription]", "myQQQuery", "[ProductDescription] <='" & [ProductDescription] & "'") AS RowNum FROM myQQQuery;", dbOpenSnapshot)

[ItsMe]

...
How to convert it?

What are you trying to build, a query Object? It seems what you have there is a DAO recordset. The recordset uses the variable, "[ProductDescription]". So, if you are building a query object, you will have to pass the value to the query object.