currency symbol in reports

[Mark Andrews]

I would like to make the currency symbol on all numeric fields in a report
to show the appropriate currency
based on user selection. In this example the amounts are all expressed as
the currency picked by the user on an ASP web page.

However the query which drives the report has the currency code (USD, GBP,
CAD, EUR etc...)

Advise on how to accomplish this?

Thanks in advance,
Mark

 

[Brendan Reynolds]

How about creating a table with the symbols and the codes and joining it to
your existing query?

SELECT YourQuery.*, CurrencyTable.CurrencySymbol FROM YourQuery INNER JOIN
CurrencyTable ON YourQuery.CurrencyCode = CurrencyTable.CurrencyCode