Currency and euro in reports

[JackAtArcLight]

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 report to
display the appropriate currency symbol?

 

[pietlinden]

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 report to
display the appropriate currency symbol?

put the currency type in another column and then set the format based
on that other column...