# Adding Maximum values

=?Utf-8?B?TkI=?=
Guest
Posts: n/a

 3rd Mar 2007
I'm sure this has an easy answer, but I have not been able to figure it out.

I've create a report that calculates the maximum enrollment for each
preschool. I did it using the following fields in the given sections:

Detail section: [Enrollment]
Provider Footer: =Max([Enrollment]

I need a sum of all the Max([Enrollment]) for a grand total at the bottom,
but I can't figure out the proper expression. Everything I try yields an
error message. Thank you for your help!

Allen Browne
Guest
Posts: n/a

 3rd Mar 2007
In the Provider footer section, place another text box, and set these
properties:
Control Source =[Text1]
Running Sum Over All
Visible No
Format General Number
Name txtMaxOfEnrollmentRS
replacing Text1 with name of the text box you already have.

In the Report Footer section, place a text box with Control Source of:
=[txtMaxOfEnrollmentRS]

The invisible text box collects the running sum across the whole report, and
the final text box in the report footer displays it.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"NB" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I'm sure this has an easy answer, but I have not been able to figure it
> out.
>
> I've create a report that calculates the maximum enrollment for each
> preschool. I did it using the following fields in the given sections:
>
> Detail section: [Enrollment]
> Provider Footer: =Max([Enrollment]
>
> I need a sum of all the Max([Enrollment]) for a grand total at the bottom,
> but I can't figure out the proper expression. Everything I try yields an
> error message. Thank you for your help!

=?Utf-8?B?TkI=?=
Guest
Posts: n/a

 8th Mar 2007
Allen,
Sorry it took me a while to get back to you. In the meantime, I had to add
another group (region) to the report.

I was able to get the running sum going, and get a subtotal in the Provider
footer, and region footer, but the grand total still wasn't adding up.

But because your instructions were so clear and easy to follow, I took your
the Region footer, naming it, and having the grand total call on that name.
Now it works like a charm.

Thank you so much for your help. You are the best!

"Allen Browne" wrote:

> In the Provider footer section, place another text box, and set these
> properties:
> Control Source =[Text1]
> Running Sum Over All
> Visible No
> Format General Number
> Name txtMaxOfEnrollmentRS
> replacing Text1 with name of the text box you already have.
>
> In the Report Footer section, place a text box with Control Source of:
> =[txtMaxOfEnrollmentRS]
>
> The invisible text box collects the running sum across the whole report, and
> the final text box in the report footer displays it.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "NB" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > I'm sure this has an easy answer, but I have not been able to figure it
> > out.
> >
> > I've create a report that calculates the maximum enrollment for each
> > preschool. I did it using the following fields in the given sections:
> >
> > Detail section: [Enrollment]
> > Provider Footer: =Max([Enrollment]
> >
> > I need a sum of all the Max([Enrollment]) for a grand total at the bottom,
> > but I can't figure out the proper expression. Everything I try yields an
> > error message. Thank you for your help!

>
>

Allen Browne
Guest
Posts: n/a

 8th Mar 2007
Well done!

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"NB" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Allen,
> Sorry it took me a while to get back to you. In the meantime, I had to
> another group (region) to the report.
>
> I was able to get the running sum going, and get a subtotal in the
> Provider
> footer, and region footer, but the grand total still wasn't adding up.
>
> But because your instructions were so clear and easy to follow, I took
> your
> in
> the Region footer, naming it, and having the grand total call on that
> name.
> Now it works like a charm.
>
> Thank you so much for your help. You are the best!
>
>
> "Allen Browne" wrote:
>
>> In the Provider footer section, place another text box, and set these
>> properties:
>> Control Source =[Text1]
>> Running Sum Over All
>> Visible No
>> Format General Number
>> Name txtMaxOfEnrollmentRS
>> replacing Text1 with name of the text box you already have.
>>
>> In the Report Footer section, place a text box with Control Source of:
>> =[txtMaxOfEnrollmentRS]
>>
>> The invisible text box collects the running sum across the whole report,
>> and
>> the final text box in the report footer displays it.
>>
>> "NB" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > I'm sure this has an easy answer, but I have not been able to figure it
>> > out.
>> >
>> > I've create a report that calculates the maximum enrollment for each
>> > preschool. I did it using the following fields in the given sections:
>> >
>> > Detail section: [Enrollment]
>> > Provider Footer: =Max([Enrollment]
>> >
>> > I need a sum of all the Max([Enrollment]) for a grand total at the
>> > bottom,
>> > but I can't figure out the proper expression. Everything I try yields
>> > an
>> > error message. Thank you for your help!

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 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 OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post dhstein Microsoft Access 2 12th Jan 2009 02:39 AM Code Numpty Microsoft Excel Charting 1 19th Nov 2008 08:29 AM =?Utf-8?B?TXJOb2JvZHk=?= Microsoft C# .NET 2 9th Nov 2006 04:52 PM =?Utf-8?B?c2hhcnJpcw==?= Microsoft Access Getting Started 7 17th Oct 2005 05:23 PM mayur Microsoft ASP .NET 2 2nd Jul 2004 11:35 AM

Features