<div>
You need to DSUM on the query that contains the calculation not the table.
</div>


You need to DSUM on the query that contains the calculation not the table.

<div>
OK. &nbsp;I guess I need to make a saved query because the query only resides on the record source of form?
</div>


OK.  I guess I need to make a saved query because the query only resides on the record source of form?

<div>
thank you....will be asking a similar question in just a minute.
</div>


thank you....will be asking a similar question in just a minute.

<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I have the following Dsum in a subform:<br />
<br />
=DSum(&quot;[USDEquiv]&quot;,&quot;tblFXR<wbr />ates&quot;,&quot;[Pr<wbr />ojID]=&quot; &amp;&nbsp;Nz([ProjID],0))<br />
<br />
Wouldnt this Sum all USDEquiv for ProjID = ProjID?<br />
<br />
USDEquiv is a calculated field (see pic). &nbsp;the Dsum is not summing and only thing I can think of is USDEquiv is a calcualted field and not a field in tblFXRates. &nbsp; The ProjID's are populated. <br />
<br />
here is the calcualted field as shown in the pic: <br />
USDEquiv: IIf([CurrencyID]=1,[tblFXR<wbr />ates].[Amo<wbr />unt],([tbl<wbr />FXRates].[<wbr />Amount]*[E<wbr />xchangeRat<wbr />e]))<br />
<br />
thank you. <br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/12_w49/691270/untitled.JPG" target="_blank" title="tblFXrates,query (52 KB)"><img alt="tblFXrates,query" class="file-block lazyload" style="max-width: 748px;" data-src="https://filedb.experts-exchange.com/incoming/2013/12_w49/691270/untitled.JPG" /></a>
</div>
</div>


untitled.JPG

Experts,

I have the following Dsum in a subform:

=DSum("[USDEquiv]","tblFXRates","[ProjID]=" & Nz([ProjID],0))

Wouldnt this Sum all USDEquiv for ProjID = ProjID?

USDEquiv is a calculated field (see pic).  the Dsum is not summing and only thing I can think of is USDEquiv is a calcualted field and not a field in tblFXRates.   The ProjID's are populated. 

here is the calcualted field as shown in the pic: 
USDEquiv: IIf([CurrencyID]=1,[tblFXRates].[Amount],([tblFXRates].[Amount]*[ExchangeRate]))

thank you. 



Dsum help

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.