Converting Currency to obtain total for report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top