<div>
Try grouping your report by projects.ID. &nbsp;Place a textbox in the group header or footer section, and set it's control source to:<br />
<br />

<pre><code id="code-20-39698362-1"> = Format( SUM( ABS([tblCurrencyExchange].[CurrencyID]=1) * [tblFXRates]![Amount]*[tblCurrencyExchange]![ExchangeRate]), &quot;Currency&quot;)</code></pre>
</div>


Try grouping your report by projects.ID.  Place a textbox in the group header or footer section, and set it's control source to:



 = Format( SUM( ABS([tblCurrencyExchange].[CurrencyID]=1) * [tblFXRates]![Amount]*[tblCurrencyExchange]![ExchangeRate]), "Currency")

<div>
Or possibly this, and do the formatting through the textbox properties instead of in the expression:<br />
<br />

<pre><code id="code-20-39698369-1"> = SUM( ABS([tblCurrencyExchange].[CurrencyID]=1) * [tblFXRates]![Amount]*[tblCurrencyExchange]![ExchangeRate])</code></pre>
</div>


Or possibly this, and do the formatting through the textbox properties instead of in the expression:



 = SUM( ABS([tblCurrencyExchange].[CurrencyID]=1) * [tblFXRates]![Amount]*[tblCurrencyExchange]![ExchangeRate])

<div>
Glad to help and thanks for the points.<br />
<br />
ET
</div>


Glad to help and thanks for the points.

ET

<div>
<div class="content wysiwyg-content">
Experts, <br />
<br />
I have a calculated field in the control source of a report:<br />
USD Equivalent: IIf([tblCurrencyExchange].<wbr />[CurrencyI<wbr />D]=1,&quot;&quot;,Fo<wbr />rmat(([tbl<wbr />FXRates]![<wbr />Amount]*[t<wbr />blCurrency<wbr />Exchange]!<wbr />[ExchangeR<wbr />ate]),&quot;Cur<wbr />rency&quot;))<br />
<br />
<br />
I need to sum this USD Equivalent but for each [projects].[ID]<br />
I have an idea how to do it but something is not correct. &nbsp; <br />
I can not sum it on the report face (doesnt allow since it is calculated)...need to sum <b>in the query design window</b>. <br />
<br />
thank you...let me know if you need additional info.
</div>
</div>


Experts, 

I have a calculated field in the control source of a report:
USD Equivalent: IIf([tblCurrencyExchange].[CurrencyID]=1,"",Format(([tblFXRates]![Amount]*[tblCurrencyExchange]![ExchangeRate]),"Currency"))


I need to sum this USD Equivalent but for each [projects].[ID]
I have an idea how to do it but something is not correct.   
I can not sum it on the report face (doesnt allow since it is calculated)...need to sum in the query design window. 

thank you...let me know if you need additional info.

Sum 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.