In a contact ID Footer, I have a text box that contains:
=Min([Pledge Amount])

This gives me the number I want (the minimum of the amounts that appear in
the "Pledge Amount" fields). At the report footer, however, I would like to
sum all values in the contact ID footer text boxes rather than ALL "Pledge
Amounts" - I want ONLY the MIN of the "Pledge Amounts" to be summed in the
footer. Can you help me adjust the formula below to sum only the MINs??

=Sum([Pledge Amount])
Thanks in advance!

At least one reply in a more recent thread with the same question.
--
Duane Hookom
MS Access MVP


"Brenda Fry" <(E-Mail Removed)> wrote in message
news:8ECAA47A-1A31-44FC-82FD-(E-Mail Removed)...
> In a contact ID Footer, I have a text box that contains:
> =Min([Pledge Amount])
>
> This gives me the number I want (the minimum of the amounts that appear in
> the "Pledge Amount" fields). At the report footer, however, I would like
> to
> sum all values in the contact ID footer text boxes rather than ALL "Pledge
> Amounts" - I want ONLY the MIN of the "Pledge Amounts" to be summed in the
> footer. Can you help me adjust the formula below to sum only the MINs??
>
> =Sum([Pledge Amount])
> Thanks in advance!