I am trying to show a count of Regulatory items and a sum for Consent.
In the control source I have wrote:
IIF(Count([Total Subjects])=Regulatory Or IIF(Sum([Total Subjects])=Consent
Of course this isn't working.
When the report is selected I have a criteria (Like "*" & [Enter: Consent or Regulatory] & "*") through my Query that I use to select either Consent or Regulatory that only shows one of them with a count. The problem is I don't want to sum the Regulatory but need a count and a sum for Consent. Regualtory almost always give me a 0. Consents give me the amount of were audited to the reason why I need to show sum.