display in different currency

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

Guest

I would like to display in another currency.
Example : $100,000 should be displayed as Rs. 1,00,000

Any ideas?

Thanks
 
hi,
it's a simple math problem....$100,000 * exchange rate.
but you didn't say were you were getting the $100,000 nor
how you entended to use it. in a query, from a query, in a
report, on a form from a query?
best guess. [$controlName]*[ERcontrolname]
where [$controlName] is the control that houses the
$100,000
and
[ERControlName] is the control that houses the exchange
rate.
???
regards
Frank
 
I am sorry for not being very clear Frank. I am calculating off of 2 tables.
My problem is not the calculation but the display. Here, we display as $
100,000 whereas in India (example) they display as Rs.1,00,000.

Frank Stone said:
hi,
it's a simple math problem....$100,000 * exchange rate.
but you didn't say were you were getting the $100,000 nor
how you entended to use it. in a query, from a query, in a
report, on a form from a query?
best guess. [$controlName]*[ERcontrolname]
where [$controlName] is the control that houses the
$100,000
and
[ERControlName] is the control that houses the exchange
rate.
???
regards
Frank
-----Original Message-----
I would like to display in another currency.
Example : $100,000 should be displayed as Rs. 1,00,000

Any ideas?

Thanks
.
Click to expand...
Click to expand...
 
Back
Top