I am trying to create a count formula in a Access Report.
If, the [repName] from "GSC Reporting" query equals "CARD", then I want to count the number of "High Issues" from the [HIGH_ISSUE_COUNT] field.
I am trying:
=DCount("[High_Issue_Count]","GSC Reporting","[repName]='CARD'")
But the total is way more than it should be.
If, the [repName] from "GSC Reporting" query equals "CARD", then I want to count the number of "High Issues" from the [HIGH_ISSUE_COUNT] field.
I am trying:
=DCount("[High_Issue_Count]","GSC Reporting","[repName]='CARD'")
But the total is way more than it should be.