currency symbol in reports

M

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
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dynamic currency formatting in a report 3
Change currency symbol in reports dynamically 4
Foreign Currency on Reports 1
Display different currency symbol 4
Format currency field on report. 3
currency code to symbol 3
foreign currency querry and design question 2
Match a currency with its corresponding value 4

Top