Hello,
I am trying to count records in a report based on other fields in the report.
I have two fields: [Service], and [Service Month]
Basically, I want to place a text box on the report that counts the number of records where [Service]="ASSESSMENT" & [Service Month]="7"
I put this in the control source of the text box on the report:
=Count((IIf([Service]="ASSESSMENT" & [Service Month]="7",0)))
However, this doesn't seem to be working. I would rather not do the count in the query that feeds the report becuase I would like to use the report to count other fields as well.
Is there another way to do this?
I am trying to count records in a report based on other fields in the report.
I have two fields: [Service], and [Service Month]
Basically, I want to place a text box on the report that counts the number of records where [Service]="ASSESSMENT" & [Service Month]="7"
I put this in the control source of the text box on the report:
=Count((IIf([Service]="ASSESSMENT" & [Service Month]="7",0)))
However, this doesn't seem to be working. I would rather not do the count in the query that feeds the report becuase I would like to use the report to count other fields as well.
Is there another way to do this?