Posted on 2013-12-05
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.