I have a report that in one column I have a mix of YES's and NO's and I'm trying to add only the yes's and get a total. From research DCount is my best choice I believe to make this work. The report is pulling its data from query "Weekly Report Filter" and the field that is storing the YES's and NO's is [FORM104]. So far this is the code but its giving me a total of "1" even if there is no YES in the list... Any help would be appreciated.
=DCount("[FORM104]","Weekly Report Filter","[FORM104] = 'YES' ")
=DCount("[FORM104]","Weekly Report Filter","[FORM104] = 'YES' ")