Expected End Of Statement Dcount, Access 2003

[DetrieZ]

I am trying to set the rowsource of a LisBox



This works in a query

SELECT TBLRECORDS.RecordsID, TBLRECORDS.FileID, DCount("RecordsID","TBLRECORDS","RecordsID <= " & [RecordsID]) AS Expr1, TBLRECORDS.Internal, TBLRECORDS.Processed
FROM TBLRECORDS
WHERE (((TBLRECORDS.FileID)="51"));

but throws a Compile error expected end of statement at DCount("RecordsID" when I put it into a Dim'd statement

strLstOrders="SELECT TBLRECORDS.RecordsID, TBLRECORDS.FileID, DCount("RecordsID","TBLRECORDS","RecordsID <= " & [RecordsID]) AS Expr1, TBLRECORDS.Internal, TBLRECORDS.Processed From TBLRECORDS WHERE (((TBLRECORDS.FileID)="51"));"

[pbaldy]

The double quotes within the DCount() need to be single quotes when inside the string built in code. If you think about it, the first set before the field name argument of the DCount() terminates the quotes begun before SELECT, leaving everything after twisting in the wind.