I am trying to count a field ID from Completed (the table name) where the values in a text box (txtFinal) on a form = RPR*. It is coming up with zero records when there are several. Do I have something wrong with the syntax?
Expand|Select|Wrap|Line Numbers
- =DCount("[ID]","Completed","[txtFinal] = 'RPR*'")
I tried changing to this:
Expand|Select|Wrap|Line Numbers
- =DCount("[ID]","Completed","[Final] = 'RPR-RPR & RTN'")
Thanks in advance!
Rhonda
Thanks Neopa! Sorry about not putting the code tags in. I still have a question however. How can I count the number of records where a match is found in the subform instead of the table? It is now counting all matches in the table and not the subform.