Choose between Currency and Euro?

[Jack at ArcLight]

I have a db keeping track of potential investments, with locations all over
the world. In my investment table i have a field for the approximate
investment amount. the field is set for currency. However, for certain
european investments, the amount is based on euros. Is there a way to allow
me to choose which type of currency i can use, and then create a conversion
lookup to total the approximate investment amounts in US dollars?

 

[Fred]

Jack,

I noticed that nobody answered.

Assuming that you have the conversion factor that you want to use in the
system, then it is simple. Except that you did not give enough details on
where you want it to show up.

 

[Jack at ArcLight]

Hi Fred:

Thanks for responding. There is a report that I have created that lists the
potential deals that associates are working on. Within that report is a
column for the potential amount of investment.

In the table, that field is formatted for currency, so once a dollar amount
is added, the dollar sign pops up automatically. However, we are also
tracking deals in Europe, and the potential investment amount is calculated
in euros.

I have the factor for conversion, and will be updating it somewhat regularly.

 

[Fred]

There are lots of ways to do this, here's one that comes to mind:

Shorten my long explanatory field names

Let's assume that the conversion factor to multiply euros by to get dollars
is .714 m

Use a straight numeric field (not currency) "DealSizeInOriginalUnits"
Have another field "CurrencyUnits" with a dropdown with 2 choices "D" for
dollars and "E" for euros and set it for madnatory completion.

Name the display box on your report something other than a field name. Make
it's control source (untested)


="$"& iif([CurrencyUnits] = "E",[DealSizeInOriginalUnits]*
..714,[DealSizeInOriginalUnits])

You can infuse the format function into the above expression to format the
numbers more nicely

You can also get fancier by adding a more elegant way (than editing the
expression) to load the conversion rate.

 

[Jack at ArcLight]

Thanks Fred. Just what I was looking for, although i never thought to use
the currency as another field. Brilliant!

 

[Fred]

Happy to do it.