Display different currencies

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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

If statement for equivalent value of a range 4
foreign currency querry and design question 2
Conditional Formatting in Excel 1
fomula which returns the amount depending on the currency code 3
sum by currency 1
Total of a certain currency 5
Multiple variable lookup tables 3
Conditional formatting 2

Back
Top