=DCount("*","tb lMainDBASE","Ye ar([Date of Payment]) = " & [Text159]) And ([Type of Application]='New Transaction')
here is my expression in unbound textbox.
where it count record at tblMainDBASE which Date of payment is equal to text159 and type of application is equal to New Transaction. i got 6 record at the table but the unbound textbox says 0.
Can anyone help? plsss. thank you
here is my expression in unbound textbox.
where it count record at tblMainDBASE which Date of payment is equal to text159 and type of application is equal to New Transaction. i got 6 record at the table but the unbound textbox says 0.
Can anyone help? plsss. thank you
Comment