Display different currencies

G

Guest

Hello everybody.
I want a Sum column to display the currency symbol according to the currency
specified.

Currency Sum
EUR €78
USD $45
GBP £52
GBP £252
USD $145
GBP £52

Is it possible in any way?
 
D

Douglas J. Steele

Access only knows about one currency symbol at a time, and that comes from
whatever currency has been defined in Regional Settings (in the Control
Panel).

You may have to write your own function to add the symbol.
 

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

foreign currency querry and design question 2
Conditional Formatting in Excel 1
fomula which returns the amount depending on the currency code 3
Match a currency with its corresponding value 4
sum by currency 1
Binding certain rows to certain columns in GridView? 2
currency symbol in reports 1
Multiple variable lookup tables 3

Top