<div>
Max as you are using it is wrong ...the closest is Dmax but i guess this is not you want....<br />
Are you trying to get the sum of Max Values?
</div>


<div>
Hi John,<br />
&lt;Are you trying to get the sum of Max Values? <br />
I am trying to get the Max of [Cumulative Drawn] &nbsp;where [FacilityType]=[facID]
</div>


<div>
If only Max is what you want then <br />

<pre><code class="code-1 nolinks" id="code-20-41805292-1"><span>DMax(&quot;[Cumulative Drawn]&quot;),&quot;[Q_Available]&quot;,&quot;[FacilityType]=&quot; &amp; [facID])</span>
</code></pre>
</div>


<div>
=Sum(DMax(&quot;[Cumulative Drawn]&quot;),&quot;[Q_Available]&quot;,&quot;<wbr />[FacilityT<wbr />ype]=&quot; &amp;&nbsp;[facID])<br />
<br />
This may be what you are looking for. &nbsp;The Sum() is summarizing the data from the recordsource of the form or report. &nbsp;The DMax() is a domain function that is pulling up the max value for the specified key.
</div>


<div>
OK I tried both however I get a &quot;wrong number of arguments&quot; error... thank you...
</div>


<div>
Needs an ending &quot;)&quot; since you have two functions nested. &nbsp;the square brackets fool me into thinking they are parentheses.
</div>


<div>
Pat, I acttually tried that and the error is &quot;too many closing parent&quot;. &nbsp;thats what it tells me. &nbsp;Let me know what you think. &nbsp;I am about to close down the computer though so might not be able to respond for a bit.
</div>


<div>
Thank you Anders. &nbsp;If there is any objection please let me know. &nbsp;Grateful for your responses and tips how to test.
</div>


<div>
<div class="content wysiwyg-content">
Experts, is the below correct? &nbsp;I dont get a syntax. &nbsp;I get a #error when I add the Max part. &nbsp;I had no issues with the formula until I tried to add Max. &nbsp;<br />
<br />
=DSum(Max(&quot;[Cumulative Drawn]&quot;),&quot;[Q_Available]&quot;,&quot;<wbr />[FacilityT<wbr />ype]=&quot; &amp;&nbsp;[facID])<br />
<br />
thank you
</div>
</div>


Experts, is the below correct?  I dont get a syntax.  I get a #error when I add the Max part.  I had no issues with the formula until I tried to add Max.  

=DSum(Max("[Cumulative Drawn]"),"[Q_Available]","[FacilityType]=" & [facID])

thank you

Dsum and Max

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.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.