Report section totals by outcome RRS feed

  • Question

  • Hi,

    I would like to count a field in a report based on the content of that field, to go in the section footer (EnforcementType footer). So I have totals for each type of enforcement.

    So the fields are InvestigationOutcome and EnforcmentType

    Here is my current report

    Here is the design view

    Is there a solution like an IF / count?

    I tried something like this =count(Iif([EnforcementType]="A")) but no success.

    Any assistance appreciated.




    Tuesday, September 18, 2018 9:55 PM


  • For example:


    Regards, Hans Vogelaar (

    Tuesday, September 18, 2018 10:33 PM

All replies