<div>
here is the query: 
 
its big 
SELECT 
tblDraws_Details1.Amount, tblDraws_Details1.ValueDate, tblRepayment.Amount, tblRepayment.Currency, tblRepayment.ValueDate, tblRepayment.PaymentMadeYN, (DSum(&quot;Amount&quot;,&quot;tblDraws_Details1&quot;,&quot;ID = &quot;&nbsp;&amp; [DrawIDrpmt])+Nz(DSum(&quot;Amount&quot;,&quot;tblRePayment&quot;,&quot;DrawIDrpmt = &quot;&nbsp;&amp; [DrawIDrpmt] &amp;&nbsp;&quot; and PaymentMadeYN = 'Yes' &quot;),0)) AS Balance, Sum(IIf([CurrencyID]=1,Nz([TAccrueMoINLocalCurr],0),Nz(([TAccrueMoINLocalCurr]*[ExchangeRate]),0))) AS AccrueUSDEquiv, Format([tblRepayment].[ValueDate],&quot;mmmm&quot;) AS CurrentMonthToAccrue, ([Balance])*([SiborRate]+[Margin])*([DayCountToMaturity]/360) AS TInterestToMatLocalCur, ([tblRepayment].[ValueDate])-([tblDraws_Details1].[ValueDate]) AS DayCountToMaturity, DLookUp(&quot;[MarginRate]&quot;,&quot;tblInterest_Margin&quot;,&quot;[FacID]= &quot;&nbsp;&amp; [tblRepayment].[ID_Facility]) AS Margin, tblInterest_Sibor.SiborRate, ([Balance])*([SiborRate]+[Margin])*([DaysToAccrueCurMo]/360) AS [TAccrueCurrMo(InLocalCurr)], tblCurrencyExchange.CurrencyName, [tblRepayment].[ValueDate]-dhFirstDayInMonth([tblRepayment].[valuedate])+1 AS DaysToAccrueCurMo, tblRepayment.Comments 
FROM 
tblDraws_Details1 INNER JOIN ((tblRepayment LEFT JOIN tblInterest_Sibor ON tblRepayment.ID = tblInterest_Sibor.RpmtID) LEFT JOIN tblCurrencyExchange ON tblRepayment.Currency = tblCurrencyExchange.CurrencyID) ON tblDraws_Details1.ID = tblRepayment.DrawIDrpmt 
WHERE 
(((Format([tblRepayment].[ValueDate],&quot;mmmm&quot;))=Format(Date(),&quot;mmmm&quot;)) AND ((tblDraws_Details1.ID_facility)=15)) 
ORDER BY 
tblDraws_Details1.ID;
</div>

<div>
in order to use SUM, you must use an aggregate function on the rest of the columns such as GROUP BY 
 
optionally, if you don't want to do that, you can use DSUM which needs the fieldname (or expression), table or query name, and conditions for matching
</div>

<div>
Hi Crystal, 
 
thank you. &nbsp;I didnt know I could do that. &nbsp;I would like to use the Dsum method. &nbsp; 
I simply changed Sum to Dsum and i get a wrong number of arguments error. &nbsp; 
I am sure there is more to it than simply doing what i did. &nbsp; 
 
what should I do now? &nbsp;grateful for your help.
</div>

<div>
Thank you very much. &nbsp;I will work on crafting something. &nbsp;Step by step. &nbsp; 
 
Have a good night
</div>

<div>
you're welcome ~ happy to help
</div>

<div>
<div class="content wysiwyg-content">
Experts, I am trying to add the below to a query and after doing so I get an error: &quot;YOu tried to execute a query that does not include the specified expression 'Amount' as part of an aggregate function. 
 
AccrueUSDEquiv: Sum(IIf([CurrencyID]=1,Nz([TAccrueMoINLocalCurr],0),Nz(([TAccrueMoINLocalCurr]*[ExchangeRate]),0))) 
 
Why do I get this error? &nbsp;The query works fine until I try to add this.
</div>
</div>

Experts, I am trying to add the below to a query and after doing so I get an error: "YOu tried to execute a query that does not include the specified expression 'Amount' as part of an aggregate function. 

AccrueUSDEquiv: Sum(IIf([CurrencyID]=1,Nz([TAccrueMoINLocalCurr],0),Nz(([TAccrueMoINLocalCurr]*[ExchangeRate]),0)))

Why do I get this error?  The query works fine until I try to add this.

Aggregate Function error

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.