Access 2003 Report - Sum "Gain"

[matthewR]

I have an Access report where I have columns where I would like to count the Text "Gain" at the bottom of the report for each of these columns. What would the calculation in the "Report Section" at the bottom of these columns be?

[HansV]

For a field named Result, create a text box in the report footer with control source

=Abs(Sum([Result]="Gain"))

[matthewR]

Thanks Hans - that worked.