<div>
Just add a textbox into the report footer with a controlsource of <br />
<br />
=max([Count])
</div>


Just add a textbox into the report footer with a controlsource of

=max([Count])

<div>
<div class="content wysiwyg-content">
I have a report that contains records in the detail section of the report. &nbsp;In each record is a number field named &quot;txtCount&quot;. &nbsp;Then in the footer of that group I would like to have a field that has the max number from the &quot;txtCount&quot; number in the detail section.<br />
<br />
In other words, if the detail records look like:<br />
<br />
Field1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Count<br />
Record 1 &nbsp; &nbsp; 5<br />
Record 2 &nbsp; &nbsp; 7<br />
Record 3 &nbsp; &nbsp; 12<br />
Record 4 &nbsp; &nbsp; 4<br />
<br />
Then the number I want to show in the footer is 12.<br />
<br />
How can I do this? &nbsp;What is the control source for the field in the footer?<br />
<br />
--Steve
</div>
</div>


I have a report that contains records in the detail section of the report.  In each record is a number field named "txtCount".  Then in the footer of that group I would like to have a field that has the max number from the "txtCount" number in the detail section.

In other words, if the detail records look like:

Field1          Count
Record 1     5
Record 2     7
Record 3     12
Record 4     4

Then the number I want to show in the footer is 12.

How can I do this?  What is the control source for the field in the footer?

--Steve

How identify the max number in the detail section of a report and put iit in the footer of that group

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.