how do I sum a minimum value in a report?

[Guest]

I have a Contact ID Footer text box that gives me this value:
=Min([Pledge Amount])

I would like the report footer to sum the values in these footer boxes, in
other words, sum the minimum value of "Pledge Amount", not every instance
where "Pledge Amount" appears.

How do I modify the current formula in my report footer, which reads:
=Sum([Pledge Amount])
I want ONLY the minimum values in this field to sum

Thank in advance,
Brenda

 

[Duane Hookom]

Create a new text box in the ContactID footer

Name: txtMinPledge
Control Source: =Min([Pledge Amount])
Running Sum: Over All
Visible: NO

Add a text box to your report footer:

Control Source: =txtMinPledge