PC Review


Reply
Thread Tools Rate Thread

Report footer summing

 
 
=?Utf-8?B?QnJlbmRhIEZyeQ==?=
Guest
Posts: n/a
 
      27th Jul 2006
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!
 
Reply With Quote
 
 
 
 
Duane Hookom
Guest
Posts: n/a
 
      27th Jul 2006
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!



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access Report Average Miles/Gallon in Group Footer and Report Footer? misscrf Microsoft Access 9 23rd Dec 2011 03:37 AM
Access Report Average Miles/Gallon in Group Footer and Report Footer? misscrf Microsoft Access Reports 9 23rd Dec 2011 03:37 AM
Report footer summing =?Utf-8?B?QnJlbmRhIEZyeQ==?= Microsoft Access Reports 1 25th Jul 2006 10:16 PM
summing in report at group footer chris_quinn26@yahoo.com Microsoft Access Reports 1 22nd Mar 2006 06:21 AM
Re: Summing in the page and report footer Fredg Microsoft Access Reports 0 29th Aug 2003 04:20 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:03 AM.