Solved

Currency format according to the currency type

Posted on 2013-07-01
3
395 Views
Last Modified: 2013-07-02
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
Comment
Question by:pdvsa
  • 2
3 Comments
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 39291506
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
 

Author Closing Comment

by:pdvsa
ID: 39291808
Ok thank you
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 39292332
You are welcome!

/gustav
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Access sql to sql server express 10 35
Access Crosstab Query with Multiple Values 4 32
Turn off MS Access Default=0 for Numerics 6 26
2 IIF's in Access query 25 31
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question