Converting Currency to obtain total for report

J

jk

Hello,

My DB has transactions which involves amounts in USD.How would you convert
the USD totals or show both the grand total in usd and the grand total in
another currrency such as a fixed exchange rate for brazillian reias?

Thanks
 
T

Tom Lake

Hello,
My DB has transactions which involves amounts in USD.How would you convert
the USD totals or show both the grand total in usd and the grand total in
another currrency such as a fixed exchange rate for brazillian reias?
Click to expand...

Create another field that simply multiplies the USD value by the exchange
rate.

Example:

If you have a control called Total In USD

Add a second control called Total In BRL with the Data Source =[Total In
USD] * 2.827


Tom Lake
 
Top