=DCount("*","tblMainDBASE","Year([Date of Payment]) = " & [Text159]) AND ([Type of Application] = 'New Transaction' ")

This is my expression on unbound textbox

What i am expecting is count all record on tblMainDBASE with date of payment is equal to text159 and type of application is equal to New Transaction

CodePudding user response：

Correct the concatenating:

=DCount("*","tblMainDBASE","Year([Date of Payment]) = " & [Text159] & " AND [Type of Application] = 'New Transaction'")