<div>
if this is a report, you might want to consider the RunningSum property of a textbox.<br><br>But instead of DLOOKUP, why don't you use DSUM("Amount", "tblPayments", "[LCID] = " &amp; [LetterOfCreditID]).<br><br>I think you could probably get rid of the NZ in there as well.
</div>


<div>
Hi Dale,<br><br>I actually didnt need the Dlookup after using the Dsum as you state above. &nbsp;I got confused on Dlookup. &nbsp;<br><br>I need to add a condition to the false part. &nbsp;<br><br>Currently, the Dsum sums all of the records for "Amount","tblPayments","[LCID] = " &amp; [LetterOfCreditID])) but &nbsp;I need for the Dsum to only sum for the below condition on another checkbox called PAIDYN (see bold below):<br><br>the condition:<br>If Dlookup PAIDYN = True then sum those records on "Amount","tblPayments","[LCID] = " &amp; [LetterOfCreditID])<br>SumPayments: IIf([PaidInFullYN]=True,"Paid In Full",<strong>DSum("Amount","tblPayments","[LCID] = " &amp; [LetterOfCreditID]))</strong><br><br>I dont think I can use SUM in the query design window because I get an error when I change Dsum to Sum. &nbsp;Also, tblPayments is not in the query and I cant drag it in because it messes up the record count so I might need to use dlookup. (i dont know).
</div>


Project finance

pdvsa

<div>
Hi Crystal, &nbsp;(typing from phone) thank you for the comment. I actually did exactly what you said and it does work. I did not add that query to the recorsource but i instead used Dsum on the report. &nbsp;I ran into another problem in that access wont allow to sum this field on the report footer. Its like I solve one problem but then have another.<br><br>Do you have a work around suggestion?
</div>


<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I need to sum tblPayments.Amount in the below. &nbsp;How can I do this? &nbsp;I have tried to put the word SUM in many places. &nbsp; <br />
This is a field in a report. <br />
I can not drag in tblPayments to the query so I need the Dlookup. &nbsp;<br />
&nbsp; <br />
<br />
=IIf([PaidInFullYN]=True,&quot;<wbr />Paid In Full&quot;,Format(Nz(DLookUp(&quot;[<wbr />Amount]&quot;,&quot;<wbr />tblPayment<wbr />s&quot;,&quot;[LCID]<wbr /> = &quot;&nbsp;&amp; [LetterOfCreditID]),0),&quot;Cu<wbr />rrency&quot;))
</div>
</div>


Experts,

I need to sum tblPayments.Amount in the below.  How can I do this?  I have tried to put the word SUM in many places.   
This is a field in a report. 
I can not drag in tblPayments to the query so I need the Dlookup.  
  

=IIf([PaidInFullYN]=True,"Paid In Full",Format(Nz(DLookUp("[Amount]","tblPayments","[LCID] = " & [LetterOfCreditID]),0),"Currency"))

Summing in a Report

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.