[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 419
  • Last Modified:

Currency format according to the currency type

experts,

I have a report that is in difference currencies.
I want the currency to format according to the currency indicated (ie Euro, NOK, GBP...).
I have a currency table within the db that is used to convert to USD.  
I am using access 2010.  

Is there a solution to this within 2010 or does this have to be specially coded?  

thank you.
0
pdvsa
Asked:
pdvsa
  • 2
1 Solution
 
Gustav BrockCIOCommented:
It has to specially coded.
You must store the values together with information about the currency for each record.
Then, in your report, you can use the info about currency to label the amount.

/gustav
0
 
pdvsaAuthor Commented:
Ok thank you
0
 
Gustav BrockCIOCommented:
You are welcome!

/gustav
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now